This function cannot be used because it must be evaluated later 1

[Mitchels]

I have a report that was previously written - I am trying to only show items that have a >0 result of a sum formula. I created a formula where table.field is > 0 and added it to the record select but I am getting this error. I then edited the formula to read

WhilePrintingRecords:
table.field > 0

Still getting the same error. Need help figuring out how to use this 2nd pass formula.

 

[hilfy]

Get rid of the "WhilePrintingRecords". I wouldn't use a formula, I'd just go to the Select Expert, select table.field "Is greater than" and type in the number 0.

You can't use aggregate (sum, max, count, etc.) or processing time (WhileReadingRecords, WhilePrintingRecords, etc.) functions when selecting records - the aggregate functions will work in group selections, though.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[Mitchels]

My formula is not available in the Select Expert.

Can you please give further instructions as to how to use the aggregate functions that you recommend?

The scenario is:
I only want to see the sum of charges, if both fields of the summed payments and summed adjustments do not equal zero.

I need to evaluate summed fields.

 

[lbass]

Go to report->selection formula->GROUP and enter:

sum({table.payment},{table.groupfield})<>0 and
sum({table.adjustments},{table.groupfield})<>0

-LB