if (amount is negative) then sum(negative amounts)
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?