Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have two dimension Gross_BRK & TOT_Passout.
TOT_Passout | GROSS_BRK | |
-13.1 | 0 | |
35.4 | 53.1 | |
35.83 | 53.75 | |
54.195 | 81.3 |
I have an expression where I have written,
if(SUM(TOT_PASSOUT)<0,
SUM(Gross_BRK)
,
(SUM(Gross_BRK)-SUM(TOT_PASSOUT))
)
Here Net_Amount should be 62.72 but I am getting 75.82.
The Negative numbers are not been considered in this expression.
Can anyone help me where the Negative No should be considered.
Thanks & Regards,
Renuka S
Simpler, but equivalent to the above:
=Sum(GROSS_BRK - RangeMax(0, TOT_Passout))
If either value could be NULL:
=Sum(RangeSum(GROSS_BRK, -RangeMax(0, TOT_Passout)))
Which chart you are using and what is the dimension you are using. Keep in mind 0-(-13.1) is +13.1. If you can share more info, will understand better.
Hi Digvijay,
Thanks for your prompt reply.
I tried using Pivot as well as Straight Table, Dimension is only Date.
I have written condition that if my TOT_PASSOUT<0 then Considered SUM(GROSS_BRK).
But this is not working its not working...
If you change expression total to sum of rows it shows correctly.
I tried this, but I want two show in Pivot Table, Sorry as I said only Date as Dimension but there is one more dimension as Source ID
Thanks & Regards,
Renuka S
This works perfectly for you -
Sum(if(TOT_Passout<0,GROSS_BRK,GROSS_BRK-TOT_Passout))
Simpler, but equivalent to the above:
=Sum(GROSS_BRK - RangeMax(0, TOT_Passout))
If either value could be NULL:
=Sum(RangeSum(GROSS_BRK, -RangeMax(0, TOT_Passout)))
Hi,
Actually My expression is this
IF(Value='Gross',SUM({$<Segment={'Equity'}>}Gross_BRK)/vLakhs,
IF(Value='Net',
if(SUM({$<Segment={'Equity'}>}TOT_PASSOUT)<0,
SUM({$<Segment={'Equity'}>}Gross_BRK)/vLakhs
,
(SUM({$<Segment={'Equity'}>}Gross_BRK)-SUM({$<Segment={'Equity'}>}TOT_PASSOUT))/vLakhs
)
))
Thanks & Regards,
Renuka S
Hi,
Thank you Jonathan its working.
Thanks & Regards,
Renuka S