Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Betty
what u r getting on sum(Value)
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
Hi,
You can use advanced aggregation to get the sum of rows:
=Sum( Aggr( YourExpression, Type))
sum(aggr(sum(value),month))
Thanks Marcus.
Regards,
Helen