multiple if condition Expression

[#1]

Hello all,

I need your help to solve my problem :

my expression is : if(isnull(Budget),SUM(Budget_C)- SUM(Budget), SUM(Budget) - SUM(Budget_C))

i need to add a condition in this expression: when the difference SUM(Budget_C)- SUM(Budget) is less than 0.25, i put 0 else i let the value found of SUM(Budget_C)- SUM(Budget), and the same for the second difference

SUM(Budget) - SUM(Budget_C).

Thank you for your help!

[tamilarasu]

Hi Sinhaam,

You can try,

if(isnull(Budget),if(Sum(Budget_C)- Sum(Budget)<0.25,0,Sum(Budget_C)-sum(Budget)), if(Sum(Budget) - Sum(Budget_C)<0.25,0,sum(Budget)-sum(Budget_C)))

Not tested. let me know..

[sunny_talwar]

So if Budget is null, Sum(Budget) should be 0. May be try this:

If(Len(Trim(Budget)) = 0,

If(Sum(Budget_C) < 0.25, 0, Sum(Budget_C)),

If((Sum(Budget) - Sum(Budget_C)) < 0.25, 0, (Sum(Budget) - Sum(Budget_C))))

[tamilarasu]

Yes Sunny. I too thought the same.. but i dont know what he is trying to do.. Let us wait for the reply..

[#5]

it's works, thank you for your help !