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