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

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

    Sergejs Kazakevics


      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,