1 Reply Latest reply: Oct 11, 2013 4:07 AM by Michele Barini RSS

    Suntax in formula

      Good day all,

       

      I want to calculate our Bad Debt provsion for each of our Companies.

       

      The Companies info gets pulled from the same system (the one is just on a newer version). So, for the one company the bad debts provsion account is 0409 and for the other comany it is 007600.

       

      How I can I type my formula, so that if the companyKey is 01 he should sum the 'Provision Value' of ExpenseCode 0409, but for the other Company (CompanyKey 20) he should sum the "Provision Value' of expense code '007600'?

       

      It is exactly the same table it is pulling from, so the Provision Value is the same field for both companies, but the expense code for these two companies differ.

       

      Thanks

      *R*