Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can try like this Sum(if(Column_Name)<0,Column_Name).Same you can get in Set Analysis
-Jai
Hi,
You can try like this Sum(if(Column_Name)<0,Column_Name).Same you can get in Set Analysis
-Jai
Thanks Jai,
Thats easy and correct. I should take a rest.
~Sergejs
HI,
PFA. Hope this is of some help. Jai is also telling the same concept.
Have you got any example how to realise this with set analysis as well?
Best Regards,
~Sergejs
Thanks Sharma,
Nice example and very helpful.
Best Regards,