Text in chart, num() not working

[Michiel_QV_Fan]

Hi,

I have this expression as text in chart:

= 'Value: '&

((1 -round

(sum({$<Year_A= {"<=$(=Year-1)"},Year_B= {">=$(=Year-1)"} , Waiting_days = {"< 366"} >}Waiting_days

) /

sum({$<Year_A= {"<=$(=Year)"},Year_B= {">=$(=Year)"}, Wainting_days = {"< 366"} >}Waiting_days), 0.01))*100)

I want to have a % format and added num (expression), '###.#%') but this results in nothing.

I don't know why.

All help is appreciated.

[Miguel_Angel_Baeyens]

Hello Michiel,

Make sure your format options follows your DecimalSep and ThousandSep variables at the top of your main script tab. Num syntax is

Num(expression, '#.##0,00 %')

in my case, using "." for thousands and "," for decimals. Check for missing brackets.

Regards.

[Michiel_QV_Fan · Accepted solution]

Tnx Miguel,

I found the solution. The first comma in the script messed the expression because the num expected this comma. I removed the round function and added the num(). Now I have the desired output.

Thanks

Michiel