GAUGE not displaying crrect value

[theboss-123]

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%')

[luizcdepaula]

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

[theboss-123]

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

[luizcdepaula · Accepted solution]

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%')

[theboss-123]

Thanks The Big Boss that works fine

[luizcdepaula]

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