I have the following measure -
(sum([Actual - YTD])-$(vPriorPeriodAdjustmentYTD))/($(v_rounding)
this gives me a result of £69,180,466 but i would like to show it as - £69,180
I assume i need a num function but it doesn't seem to change anything
Go like this:
... or wrap your expression in a NUM function.
Retrieving data ...