This content has been marked as final. Show 2 replies
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