Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps is this:
Num(
(
Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)
/
Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)
)
-1 ,'#,##0.00%')
Try this:
=Num(((Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)
/
Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User))-1) ,'#,##0.00%')
=
(
Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)
/
Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)
)
-1
and format the expression in number tab
is Mandatory by using NUM()
Sorry but the useful answer is identical to mine, I have answered before ....
If you are specifying the format at the end, you do need the Num() function. Else you can look at maxgro's suggestion
hi sunny,
i need your help on the thread 181882.
please have a look
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