Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi in the following example i have the following;
the percentage should be accumulating so for example it starts at 7 but the next steps should be 0,32% instead of 57% and so forth.
my calculation is as follows column (11) / Column (12) and set to percent.
any help would be greatly appreciated.
Best Brad
Hi,
You need to create a hidden expression for this
Doi Ack Accumulation = Alt(Above([Doi Ack Accumulation]), 0) + [Doi Ack]
Doi ack Plan Accumulation = Alt(Above([Doi ack Plan Accumulation]), 0) + [Doi ack Plan]
Index Per Day will be [Doi Ack Accumulation] / [Doi ack Plan Accumulation]
thank you for your advise!
i have attached my document to explain the issue further.
i could not follow the logic you provided as i had false refernces to the dimensions *.. Accumulation....*
thank you in advance.
Brad