Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
With reference to above subject, I am trying below formula in expressions but getting "Error in Expression".
(Sum(if(Levels = 'Level*', (Gross),'NA'))) / (sum((if(Levels = 'Level*', total (Gross),'NA'))))
Please see the above and help me to identify where I am making mistake.
Thanks in advance.
Abhijit ARANKALLE.
Perhaps this?
Alt(Sum({<Levels = {'Level*'}>} Gross)/Sum({<Levels = {'Level*'}>} TOTAL Gross), 'NA')
Or, For me this is suffice
Alt(Sum({<Levels = {'Level*'}>} Gross)/Sum(TOTAL Gross), 'NA')
Perhaps this?
Alt(Sum({<Levels = {'Level*'}>} Gross)/Sum({<Levels = {'Level*'}>} TOTAL Gross), 'NA')
Or, For me this is suffice
Alt(Sum({<Levels = {'Level*'}>} Gross)/Sum(TOTAL Gross), 'NA')
Hi
Thanks a lot for your response. It working fine in total but when I am adding quarter fields in pivot - column, then I am getting incorrect results by quarter.
Thanks and Regards,
Abhijit ARANKALLE.
Hi
Please see attached. The red one is current result and green colour is I am expecting.
Thanks and regards,
Abhijit ARANKALLE.
Try this
Sum(Gross)/Sum(TOTAL <EncDate.YearQuarter> Gross)
Hi
I tried this but it is taking percentage for NULL values also.
Hi
Please see attached file for details.
Thanks and Regards,
Abhijit ARANKALLE.