Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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*
HI,
you could solve in the script, you can create a table with the "bad" expense code for each company.