could you please tell What does the sum function do in expression definition?
sum(If ([Products].[Sales].[STATUS] IN ('Success'))
THEN (1)
ELSE (0) )
Quote from: priyanka on 24 Dec 2015 08:20:54 AM
could you please tell What does the sum function do in expression definition?
sum(If ([Products].[Sales].[STATUS] IN ('Success'))
THEN (1)
ELSE (0) )
Hi
If ([Products].[Sales].[STATUS] IN ('Success'))
THEN (1)
ELSE (0)This returns a 1 or a 0 for each product sale. If you have 1000 sales you will have a mixture of 1000 1 and 0 values returned.
sum([the expression above]) will return the sum of these 1 and 0 values.
MF.
Addition to that..
As far as I remember, we don't have the function named as 'SUM' in Report Studio. It should be 'TOTAL'.
Please correct me If i'm wrong.