Mismatch total ?

[#1]

HI All,

I am getting the Total Mismatch, I have used sum(Distinct Value ) in the Expression..

Getting the Value in the Each & every month is correct, Only thing is getting mismatch in the Total.

Kindly help me on this..

Regards,

Helen

[ajsjoshua]

Hi Betty

what u r getting on sum(Value)

[marcus_sommer · Accepted solution]

The reason for this behaviour will probably be the distinct key-word within your expression. If you really need it there you will need an aggr-function to eliminate the distinct-effect across the month. Try something like this:

sum(aggr(sum(distinct Value), Month))

- Marcus

[ajsjoshua]

Hi,

You can use advanced aggregation to get the sum of rows:

=Sum( Aggr( YourExpression, Type))

[#5]

sum(aggr(sum(value),month))

[#6]

Thanks Marcus.

Regards,

Helen