Sum(CY)/Sum(TOTAL(CY)) not working

[#1]

Hi All

I hv below expression work fine :-

Sum(sales)/Sum(TOTAL(sales))

I try below expression using label name :-

Sum(CY)/Sum(TOTAL(CY))

it does not able to work.

Can some one advise me ?

Paul

[paul_scotchford]

Paul

Moving forward, for future solutions I would see it as a priority to clean/rationalise your data model

Life will be so hard for you with a model like what you have now (no offence, but it is an example of

how not to model)...

Cheers

Paul

[#3]

Hi Scot

Thank you for reminding me again. Sure one day will come my data model will be neat.

Paul