Format value

[clovati]

Hi all. In this Example I wish to display the yellow value with decimal.

I wrote this

If (MisuraOrdinamento = 1 ,Num(Valore, '#.##0'),

If (MisuraOrdinamento = 2 ,Num(Valore, '#.##0'),

If (MisuraOrdinamento = 3 ,Num(Valore, '#.##0,##'),

)))

but it didn't Work.

In their TOTAL I want the sum for 1 and 2 and the avarage for the 3.

THANKS in advance!

[clovati]

I FOUND:

If (MisuraOrdinamento = 1 ,Num(Valore, '#.##0'),

If (MisuraOrdinamento = 2 ,Num(Valore, '#.##0'),

If (MisuraOrdinamento = 3 ,Num(Valore, '#.##0,00'),

)))

I have the problem of TOTALS 😞 thanks