How to split the expression based on a condition?

[priyav24]

Hello Everybody,

    I Have a requriment that the expression Sum(voucheramount) should be splitted into two expression like one should contain all the negative values as credit and the other one should contain Positive Values as Debit..

Thanks in Advance,

Priya

[tresesco]

Better do it in the script like this:

Load

         If(voucheramount<0, voucheramount) as Credit,

          If(voucheramount>=0, voucheramount) as Debit

From ....;

[er_mohit · Accepted solution]

sum(if(voucheramount<0,voucheramount,null())) // for credit

sum(if(voucheramount>=0,voucheramount,null())) //Debit

make sure in peresentation tab check on suppress null value

[priyav24]

Hi tresesco,

                 At the moment i could not reload ..Is there any other way to do it

Thanks,

Priya

[priyav24]

Thanks Mohit ..

[tresesco]

Then use Sum( If()) as suggested by Mohit if you are only looking for the Sum.