Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I need information about an error caused by a comparison on two fields.
the formula I used is the following:
if(Sum(Fatturato) <> sum(AdHoc_TotaleFattura), 'Totale Diverso', 'Totale Uguale')
My problem is that on equal values 0 it does not bring me 'Totale Uguale' but 'Totale Diverso' (I attach the table).
I also carried out a CAST on both indicted fields (DECIMAL (10.2)) but I can not fix the situation.
Can you give me a hand?
Thank you all
Or this
If(Round(Sum(Fatturato), 0.01) <> Round(Sum(AdHoc_TotaleFattura), 0.01), 'Totale Diverso', 'Totale Uguale')
May be this
If(Round(Sum(Fatturato)) <> Round(Sum(AdHoc_TotaleFattura)), 'Totale Diverso', 'Totale Uguale')
Or this
If(Round(Sum(Fatturato), 0.01) <> Round(Sum(AdHoc_TotaleFattura), 0.01), 'Totale Diverso', 'Totale Uguale')