Please help me with the below expression.

[#1]

  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]))

[qlikpahadi07]

attach a Sample which will be helpful

[#3 · Accepted solution]

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

[israrkhan]

HI,

What are your dimensions in Table,

[#5]

     Thank you John.It did work.

[#6]

Im glad I could help