6 Replies Latest reply on Nov 14, 2018 1:31 AM by Philippe Mudra

    True if value 1 is the same of value 2

    Philippe Mudra

      Hi there,

       

      I have a blend across two data sources.

      Customer Ref. ID from the Datasource 1 and Customer Ref. ID from Datasource 2 which I blend.

      Both have also measure USD Amount.

       

      I have different Customers with values and this formula to check if the value are the same.

       

      if SUM([DB1.[Amount]) = SUM([Amount]) then "TRUE"

      else "FALSE"

      END

       

      It's working well. But some values are wrong but they are correct. When I separate them then its true. Something is wrong here. Maybe my calculation is not going row by row? What I am missing?

       

      best, Phil