num function shows -0% when divisor is negative

[edwin]

Hi,

we are currently encountering this issue and cant find any reference to it anywhere:
when using num(formula,'#.##%;(#.##%)').  when we have normal values like 1/12, or 1/-12 we get the expected values and formats (negatives in brackets).  however, when we have calculations like 0/-12, the formatting is overridden and we get -0.00%

these are the sample scenarios:

=num(0/-12, '#.##%;(#.##%)')       =num(0/12, '#.##%;(#.##%)')      =num(1/-12, '#.##%;(#.##%)')

-0.00%

0.00%

(8.33%)

our expectation was for the first one to show 0.00%  not -0.00%

we are using Qlikview Nov 2017 SR5 Version 12.20.20600.0

i noted that when i use the desktop edition, the first scenario is represented correctly as 0.00%

thanks,

edwin.

[Brett_Bleess · Accepted solution]

This appears to be a known issue with reference QV-14869 and is fixed in 12.30 and later tracks.  You should be updating anyway, as support for 12.20 track will be ending in a couple of months, so I would suggest working on the update to 12.30 or later track to avoid being out of support come November and if you still see the issue post upgrade, open a support case with us.  I do not believe R&D will entertain address anything like this in the 12.20 track given the closeness to the support expiration of the release.  Sorry I do not have better news for you.

Regards,
Brett

[vamsee]

Meanwhile, you could try the following

If(Denominator<0, Fabs(Your Expression), YourExpression)

[edwin]

Hi, thanks Brett this is actually good news.  i will forward to our admins.

[edwin]

Hi Vamsee, thanks for the response.  we do have a work around as it is trivial once weve figured its a "bug".

[edwin]

@Brett_Bleess we finally upgraded and yes the problem was resolved.  happy ending to that chapter