Number Formatting Issue with ,'#,##0')

[Qliksand]

Hi,

I am trying to format an outcome as a percentage using ,'#,##0').

Script is:

= 'x' &'

'&
SUM (if(C = 'Y',DX))& ' '&

'('& SUM (if(C = 'Y',X))
/
SUM (if(C = 'Y',Z) ,'#,##0')

Any hints to why I would be seeing an error in expression? 

Thanks!

[Digvijay_Singh · Accepted solution]

You cannot do like this, formatting in Qlik is done using NUM() function and that is missing over here, its used something like this - Num(Sum(Value),'#,##0').

In your case the format string is not attached to any single value as well, so may be you need to do like this - 

= 'x' &'

'&
SUM (if(C = 'Y',DX))& ' '&

'('& NUM(SUM (if(C = 'Y',X))
/
SUM (if(C = 'Y',Z) ,'#,##0%')

[Qliksand]

That's perfect, thank you so much!