Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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