topic Re: GAUGE not displaying crrect value in App Development

GAUGE not displaying crrect value

theboss-123 — Thu, 04 Aug 2022 10:24:59 GMT

hello ,

please should be informed that i used set analysis to calculate sum value and that is correct in cross table but when i use gauge the value is not correct here is my formula

=num(sum({$<Dim5={'HT'}>}[Conso HT en kg])-sum({$<Dim5={'HT'}>}[Huile TR])/sum({$<Dim5={'HT'}>}[Huile TR]),'# ##0,00%')

Re: GAUGE not displaying crrect value

luizcdepaula — Thu, 04 Aug 2022 15:26:53 GMT

Hi TheBoss,

Try changing the number formatting to the below to '##,#0%'

=num(sum({$<Dim5={'HT'}>}[Conso HT en kg])-sum({$<Dim5={'HT'}>}[Huile TR])/sum({$<Dim5={'HT'}>}[Huile TR]),'##,#0%')

Cheers,

Luiz

Re: GAUGE not displaying crrect value

theboss-123 — Thu, 04 Aug 2022 15:52:42 GMT

Hi Dear Luiz i tried to changed the number formatting but the some thing i think that there is already something wrong with the calcula

Re: GAUGE not displaying crrect value

luizcdepaula — Thu, 04 Aug 2022 16:05:04 GMT

It seems you just missing brackets so the subtraction can happen first. Try the formula below:

=num((sum({$<Dim5={'HT'}>}[Conso HT en kg])-sum({$<Dim5={'HT'}>}[Huile TR]))/sum({$<Dim5={'HT'}>}[Huile TR]),'# ##0,00%')

Re: GAUGE not displaying crrect value

theboss-123 — Thu, 04 Aug 2022 16:17:31 GMT

Thanks The Big Boss that works fine

Re: GAUGE not displaying crrect value

luizcdepaula — Thu, 04 Aug 2022 16:23:17 GMT

Great to hear! If you can mark the reply as correct answer will be greatly appreciated. Cheers!