topic Re: Fields comparison in App Development

Fields comparison

stefano_bianche — Fri, 29 Dec 2017 09:29:35 GMT

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

sunny_talwar — Fri, 29 Dec 2017 16:30:44 GMT

May be this

If(Round(Sum(Fatturato)) <> Round(Sum(AdHoc_TotaleFattura)), 'Totale Diverso', 'Totale Uguale')

sunny_talwar — Fri, 29 Dec 2017 16:32:36 GMT

Or this

If(Round(Sum(Fatturato), 0.01) <> Round(Sum(AdHoc_TotaleFattura), 0.01), 'Totale Diverso', 'Totale Uguale')