13 Replies Latest reply: Apr 16, 2018 10:54 AM by Sunny Talwar RSS

    Help with expression

    Jamel Messaoud

      Hi guys,

       

      This should be simple but I'm struggling to write the correct expression!

       

      I have two measures.

       

      • Sum([Suppliers FTL Cost])
      • Sum({<[Sub Contractor Type] = {'Base Rate'}>}[Sub Contractor Rate])

       

      I want to do a count of a field where the first measure is greater than the 2nd measure (and vice versa). 

       

      Count Suppliers where Sum([Suppliers FTL Cost]) > Sum({<[Sub Contractor Type] = {'Base Rate'}>}[Sub Contractor Rate]) is basically what i want to achieve

       

      Can anyone help?

       

      Thanks

      J