Expression in straight Table

[jagjivvt]

hi

i am applying the following in and Expression

=if([Aging] = '91-120' or '121-99999', Sum (Amount))

when i apply this it return only the amount in 91-120 and the complete total.

thanks

vijay

[Anonymous · Accepted solution]

Hi Vijay, You need to specify the field twice for the two conditions in the if statement:

=if([Aging] = '91-120' or [Aging]='121-99999', Sum (Amount))

Depending on the data structure you might need to do Sum(If()) instead but you seem to get the correct result for Aging= 91-120 so it should work.