1 Reply Latest reply: Apr 15, 2011 8:56 AM by Deepak Kurup RSS

    Load certain values as negatives

    Gerhard Laubscher


      How would I go about loading the values of certain fields as negative, IF another field meets certain criteria?

      I have the following 2 fields - [Transaction Amount] and [Transaction Code].

      Certain transactions are purchase reversals, so if I load them as negative numbers it is easier for me to show the Turnover (I can just sum the totals).

      My statment must be:

      Load [Tran Amount] as negative value IF [Tran Code] = 36 or 931.