About Sum Function in expression definition

[priyanka]

could you please tell What does the sum function do in expression definition?

sum(If ([Products].[Sales].[STATUS] IN ('Success'))
THEN (1)
ELSE (0) )

[MFGF]

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

Code Select Expand

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.

Code Select Expand

sum([the expression above])

will return the sum of these 1 and 0 values.

MF.

[cvamarley]

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.