Sum if

[#1]

Hi,

I have created the following expression.

=Num(if(Sum ([Receipt_STK Value]) = Sum ([Sale_STK Value]),0,1))

It does display 0 or 1.  But i am unable to show the total i.e. sum of values on Dimensions.  I have enabled show partial sums and Sum of Rows

Venu

[jagan · Accepted solution]

Hi,

Try like this

= Sum(Aggr(if(Sum ([Receipt_STK Value]) = Sum ([Sale_STK Value]),0,1), ChartDim1, ChartDim2, .. ChartDimN))

Regards,

Jagan

[#3]

hi try this

sum(

if(

if(Sum ([Receipt_STK Value]) = Sum ([Sale_STK Value]),0,1),

[Receipt_STK Value]

)

)

[#4]

Thanks Jagan,

It worked.

I have the following expression in which i do not want to display value which are NULL.  But i  want to include Zero

=if(((Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30)) <=10,(Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30))

Regards

Venu

[jagan]

Hi,

Can you attach some sample application and come up with an example, it helps in understanding the scenario easily.

Regards,

Jagan.