2 Replies Latest reply: Dec 29, 2017 11:32 AM by Sunny Talwar RSS

    Fields comparison

    Stefano Bianchessi

      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