Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello please I need help with formatting money. Below is what I have
And below is what I have done
But I need it to read $2.47 K. Thanks
I am sure there are other ways to just format it in 'Format Pattern' but there is one extra easy way in the measure itself:
'$' & Num(2468/1000, '###.##') & ' K'
Replace 2468 with whatever you need like this:
'$' & Num(sum(Sales)/1000, '###.##') & ' K'
I am sure there are other ways to just format it in 'Format Pattern' but there is one extra easy way in the measure itself:
'$' & Num(2468/1000, '###.##') & ' K'
Replace 2468 with whatever you need like this:
'$' & Num(sum(Sales)/1000, '###.##') & ' K'
Thank you so much. It worked!