5 Replies Latest reply: Jun 1, 2011 8:01 AM by Sergejs Kazakevics

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

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?

Best Regards,

~Sergejs

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

Hi,

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

-Jai

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

Thanks Jai,

Thats easy and correct. I should take a rest.

~Sergejs

• ###### Re: if (amount is negative) then sum(negative amounts)

HI,

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

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

Thanks Sharma,