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')