Expression Total incorrect for calculated expression

[qlikmpate0]

Hi i have a calculated expression which is show an incorrect expression total, please can someone advise, I think its because my expressions is a division but not sure.

thanks in advance

regards

Mina

[sunny_talwar · Accepted solution]

Try this may be:

=Sum(Aggr(If([POLOC Bi Annual] <= 'Jan-Jun', Sum([PO Amount ($)]), 0), YourDimensions))

[qlikmpate0]

Thanks Sunny.

[sunny_talwar]

Not a problem.

I am glad I was able to help.

Best,

Sunny

[Kushal_Chawda]

what are the values in field [POLOC Bi Annual]  ? how you are doing numerical operation (<=) with string?

[qlikmpate0]

The values are 'Jan-Jun' and 'Jul-Dec'

[qlikmpate0]

The month has a number associated with it hence if its less than or equal to 6 it will have a value of Jan-Jun, otherwise it will be Jul-Dec, hope that helps