expression wrong

[#1]

i want annual growth  rate  for that i write this expression but it show the error

=

Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

/

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)-1) ,'#,##0.00%'

Thanks

Josna

[alexandros17]

Perhaps is this:

Num(

(

Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

/

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)

)

-1 ,'#,##0.00%')

[sunny_talwar]

Try this:

=Num(((Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

/

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User))-1) ,'#,##0.00%')

[maxgro]

=

(

Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

/

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)

)

-1

and format the expression in number tab

[#5]

is Mandatory by using NUM()

[alexandros17]

Sorry but the useful answer is identical to mine, I have answered before ....

[sunny_talwar]

If you are specifying the format at the end, you do need the Num() function. Else you can look at maxgro‌'s suggestion

[#8]

hi sunny,

i need your help on the thread 181882.

please have a look

[sunny_talwar]

I am working off of a personal edition of QlikView and won't really be able to open your qvw. I see a lot of experts are already to trying to help and I am sure they will def. be able to help you out.

Best,

Sunny