2 Replies Latest reply: May 15, 2014 10:10 AM by Bradl Vogl RSS

    Convert Positive to negative

    Bradl Vogl

      I have a field I/C (Credit or Invoice) in a sales journal

      There are COST and RESALE fields as well

      The data displays a positive number for each number, regardless of it being an Invoice or credit.

       

      I need to do something like:

       

      If I/C is C, then COST and RESALE are inverted to negative.

       

      Any thoughts?

       

      Thanks,

       

      Brad Vogl

        • Convert Positive to negative
          Olly Bond

          Hello Brad,

           

          This sounds like a fairly straightforward calculated field. In the table window, click on Data > Calculated Field, click on New, select Formula-based. Call the field "CORRECT COST", define the type as numeric and select the appropriate decimals and formatting.

           

          In the Formula tab, something like:

           

          If(="C";[COST]*-1;[COST])

           

          should work. You can then hide the old COST field to keep the table tidy, and repeat for RESALE.

           

          Does this solve the problem?

           

          Best wishes,

           

          Olly