topic Re: Bug with format pattern with negative values in Num() function in App Development

Bug with format pattern with negative values in Num() function

maxattar — Wed, 12 Oct 2022 09:00:55 GMT

Hi,

I cannot hide the negative sign with a format pattern in the Num function when my bar chart has a condition settled by changing a buttoned variable.

In the Num function, I try to hide the negative sign with the following patterns : # ##0;# ##0' or '0%;0%'

Both does not work (they work when there is no switch button).

The formula :

If(vSwitchQtéPourcentage='Quantité',
-Num(Count({<[Licencié sexe]={'Femme'}>}[Licencié code]),'# ##0;# ##0'),
-Num(Count({<[Licencié sexe]={'Femme'}>}[Licencié code])/Count([Licencié code]),'0%;0%')

)

The switch button and the graph are linked.

Sincerely,

Maxattar

Re: Bug with format pattern with negative values in Num() function

vinieme12 — Thu, 13 Oct 2022 03:07:25 GMT

Ensure you have selected "Measure Expression" under Number formatting

Re: Bug with format pattern with negative values in Num() function

maxattar — Thu, 13 Oct 2022 07:47:23 GMT

Hi Vinieme,

Thanks for your help but issue is still up as it was already selected.

Re: Bug with format pattern with negative values in Num() function

vinieme12 — Thu, 13 Oct 2022 08:56:36 GMT

Can you use two measures instead?

use the show/hide condition to enable disable each

Re: Bug with format pattern with negative values in Num() function

marcus_sommer — Thu, 13 Oct 2022 09:01:04 GMT

There is a negative sign before each num() which has not only an impact on the returning values else it will force a new format-evaluation on the results - returning them within the default-formattings as if no num() has been applied.

- Marcus