Hi Scott,


The error message that you are getting, ?Maximum size of report?, means that you need to reduce the size of your report. You may do this by writing your formulas more efficiently, for example:

If Category code in [?ccd?, ?cam?, ?ctp?] and points in 45.00 to 55.00 then gross profit * .20 else?

Your original formula did not work because you did not have parentheses around the ?or? statements. This means that only the last category ?ctp? was tested for the range of points. If you are using ?or? statements, you want to group them with parentheses. For example:

If (category code = "ccd" or category code = "cam" or category code = "ctp") and points in 45.00 to 55.00 then gross profit * .20 else..