Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have this script and need additionally at the last num command a high comma. Do you have ideas how to fix this issue?
if (table.Row,num((Sum({<$(vSetBudget)>}budget) )/ top(Sum({<$(vSetBudget)>}budget)) ,'0.00%')
, num(round(money(Sum({<$(vSetBudget)>}budget) /-1000))))
First time I've ever heard anyone call a quote / apostrophe a "high comma"... had to ask Google what that was.
If you just want to add a quote at the start or end of the number, you can use a regular quote with an escape:
num(sum([Total Billing] ),'#,#0.00''') or num(sum([Total Billing] ),'''#,#0.00')
If you want to use it as the thousands or decimal separator, you could try setting it as your default Money format in your script:
SET MoneyThousandSep='''';SET MoneyDecimalSep='.';SET MoneyFormat='$#,##0.00;-$#,##0.00';
money(sum([Total Billing] ),'#''#0.00')