Number format

[kev6brown]

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

Kev

[Ivan_Bozov]

Go like this:

... or wrap your expression in a NUM function.