Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've created a formula using set analysis in my chart:
=Sum({$<Source={'LBE'}>}Sales) / Sum({$<Source={'AOP-Ex Factory'}>}Sales)
I'm essentially trying to divide sales total under LBE by sales total under 'AOP-Ex Factory' to get a percentage.
Individually the numerator and denominator work and produce line graphs. However, doing one divided by the other doesn't work. Where am I going wrong?
Thanks in advance!!
no problem, glad to help.