Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following two variables with the values tested in text boxes:
I am trying to get the % change from current versus the previous as follows:
=$(vSetCurrentAvRevRx)/$(vSetPreviousAvRevRx) - 1 and formatted as a percentage in number tab option
which should give -1.56% but i am getting a different value (-.99999). My expression above should be the problem. Kindly assist.
Regards
Message was edited by: Christopher Chitemerere
Hi,
Try this
=NUM($(vSetCurrentAvRevRx)/$(vSetPreviousAvRevRx) *- 1,'#,##0.00')
Mark
hi
if your variable are holding numbers i.e they variable expression starts with '=' sign
you might want to try num(vSetCurrentAvRevRx/vSetPreviousAvRevRx - 1 ,'##0.00%')
Thanks Mark for your contribution. The expression gives a blank result.
HI,
Could be like Liron has suggested, try the below.
Mark
Thanks Liron
Your suggestion gives a blank. The expressions are as follows:
Current
Num((Sum({$<$(vSetMTD)>}[MedAid Amount])) + Num(Sum({$<$(vSetMTD)>}[Shortfall])), '$##,##0.00')/Num(Sum({$<$(vSetMTD)>}Rx), '#,##0')
Previous
Num((Sum({$<$(vSetPreviousMonth)>}[MedAid Amount])) + Num(Sum({$<$(vSetPreviousMonth)>}[Shortfall])), '$##,##0.00')/Num(Sum({$<$(vSetPreviousMonth)>}Rx), '#,##0')
hi,
try this:
=num(($(vSetCurrentAvRevRx)/$(vSetPreviousAvRevRx))-1,'# ##0,00 %')
With your expressions, it should be:
Num(
((Sum({$<$(vSetMTD)>}[MedAid Amount]) +Sum({$<$(vSetMTD)>}[Shortfall]))/Sum({$<$(vSetMTD)>}Rx))
/
((Sum({$<$(vSetPreviousMonth)>}[MedAid Amount]) + Sum({$<$(vSetPreviousMonth)>}[Shortfall]))/Sum({$<$(vSetPreviousMonth)>}Rx)),
'# ##0,00 %')
Or maybe '# ##0.00 %' it depends on your number format
Hi Christopher,
Try like,
=($(vSetCurrentAvRevRx)/$(vSetPreviousAvRevRx) )- 1
Many thanks, this does not seem to work
Thanks Tamil, i am getting a blank with your suggestions.