topic problem with "num" in QlikView

problem with "num"

Thu, 18 Aug 2016 12:20:20 GMT

Hi!

I am trying to use the num function on a box object at the GUI, bu it keeps telling me that there is a ")" expected; I have checked it tons of times and it keeps poping out, could some one please help me out detecting the error??

=num((Sum(if(subfield(CATEGORIAS,'|',2)='R&D' and year=$(vYTDYear), CostoFinal))

/Sum(if(Accountlevel1TRM=4 and year=$(vYTDYear), CostoFinal))

*-1)*100

,$(v_num_format))

and the variable v_num_format is: # ##0,0

Thank you in advance

Re: problem with "num"

marcus_sommer — Thu, 18 Aug 2016 13:07:54 GMT

I think the reason is that your format-variable is a string and needs to be wrapped with single quotes. Therefore try:

=num((Sum(if(subfield(CATEGORIAS,'|',2)='R&D' and year=$(vYTDYear), CostoFinal))

/Sum(if(Accountlevel1TRM=4 and year=$(vYTDYear), CostoFinal))

*-1)*100

,'$(v_num_format)')

- Marcus

Re: problem with "num"

Thu, 18 Aug 2016 13:09:24 GMT

nop, didnt work

Re: problem with "num"

Thu, 18 Aug 2016 13:11:50 GMT

What I need is to format the number that I get with that to only two decimals, it doesnt need to be with a variable, do you know by any chance how else can I accomplish this?

Re: problem with "num"

Thu, 18 Aug 2016 13:19:49 GMT

I did it, the problem is with in the variable, the correct way to set it is: #,##0.00 no # ##0,0 . I was missing a "," and had misplaced the "."