if (amount is negative) then sum(negative amounts)

[zekazak]

Hello,

I hope you will find the answer for me, because I couldnt.

How can I realise this logic/formula with set analysis?

if (amount is negative) then sum(negative amounts).

I've a column with numbers(Field name is Amount). Some of them are positive and some negative numbers. And I need to get only sum of negative numbers from Amount column. Is it possible with set analysis or in defferent way?

Thank you in advance!

Best Regards,

~Sergejs

[#2 · Accepted solution]

Hi,

You can try like this Sum(if(Column_Name)<0,Column_Name).Same you can get in Set Analysis

-Jai

[zekazak]

Thanks Jai,

Thats easy and correct. I should take a rest.

~Sergejs

[montubhardwaj]

HI,

PFA. Hope this is of some help. Jai is also telling the same concept.

[zekazak]

Have you got any example how to realise this with set analysis as well?

Best Regards,

~Sergejs

[zekazak]

Thanks Sharma,

Nice example and very helpful.

Best Regards,