PLD: profit & loss statement: how to add a field percentage(%)
is there anyone updated the profit & loss statement (PLD) with a new column %, it's equal to
line amount / total sales amount * 100%
I tried, but the difficult is to get the amount of "Total Sales" (F_096) for its system variable in repetitive area. I did:
a new field: F_114 --- formula === Substring (F_096,11) = 'Total SALES'
a new field: F_115 --- link to F_114, formula ==== F_083
Anywhere wrong in the setting above?
Will be very appreciated for your help.