Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to calculate the Growth Amt over the Goal amt to use as a percentage.
AGGR(SUM({$<[Metric Type]={'Actual'}>}[Deposit Growth Amt]),[Goal Employee Id]) / (AGGR(SUM({$<[Metric Type]={'Goal'}>}[Deposit Growth Amt]),[Goal Employee Id]))
Hi Aptha,
As per your requirement Im trying to understand why are you using aggr()? aggr() calculates cummulatively.
Is that what you want?
I believe you could write something like this:
num(sum({<[Metric Type]={'Actual'}>}[Deposit Growth Amt]) / sum({<[Metric Type]={'Goal'}>}[Deposit Growth Amt]),'##.##')
the num() here is optional.
as there is a check box that says "Show Relative".Please keep this Checked .
Hope this helps.
Please get back to me with the result.
Rochelle
attach a Sample which will be helpful
Hi Aptha,
As per your requirement Im trying to understand why are you using aggr()? aggr() calculates cummulatively.
Is that what you want?
I believe you could write something like this:
num(sum({<[Metric Type]={'Actual'}>}[Deposit Growth Amt]) / sum({<[Metric Type]={'Goal'}>}[Deposit Growth Amt]),'##.##')
the num() here is optional.
as there is a check box that says "Show Relative".Please keep this Checked .
Hope this helps.
Please get back to me with the result.
Rochelle
HI,
What are your dimensions in Table,
Thank you John.It did work.
Im glad I could help