Negative No. is not getting considered in IF Condition.

[renuka_sasikumar]

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

[Digvijay_Singh]

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.

[renuka_sasikumar]

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...

[Digvijay_Singh]

If you change expression total to sum of rows it shows correctly.

[renuka_sasikumar]

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

[Digvijay_Singh]

This works perfectly for you -

Sum(if(TOT_Passout<0,GROSS_BRK,GROSS_BRK-TOT_Passout))

[jonathandienst · Accepted solution]

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)))

[renuka_sasikumar]

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

[renuka_sasikumar]

Hi,

Thank you Jonathan its working.

Thanks & Regards,

Renuka S