Set analysis division

[#1]

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!!

[#2]

no problem, glad to help.