Table function not calculating results

[Jack_Sayam]

Hello,

So I have this table where the growth rate is calculating correct if it actually calculates, but some of the results of the growth rate calculate to "-", essentially nothing. Is something wrong with my expression? (=(((Sum(InvAmt))-(Above(Sum(InvAmt))))/(Above(Sum(InvAmt))))*100)

I want to calculate it when the year switches.

Thanks for your time.

[dplr-rn]

Can you re-upload the image? it is not available (for outside qlik )

[Jack_Sayam]

Thank you for replying. I had re-upload it. Please tell me if you can view it 

[sunny_talwar]

May be try this

If([Sales Rep] = Above(TOTAL [Sales Rep]),
(((Sum(InvAmt))-(Above(TOTAL Sum(InvAmt))))/(Above(TOTAL Sum(InvAmt))))*100))

[Jack_Sayam]

It does not work initially (because of expression errors) but I will edit it more and see what I can do. Thank you for your input 🙂

[dwforest]

are all the fields just straight values or does Sales include a set expression to reset on year?

This would cause problems when you remove month from the table; essentially showing null for Year.

[Jack_Sayam]

Well sales I think is just straight values has a very simple sum expression, Sum(InvAmt)

[dwforest]

Posting a sample of the qvd would be helpful to get further help