3 Replies Latest reply on Oct 8, 2018 5:05 AM by Justin Tho

    Calculation by filtering

    Justin Tho

      Hi,

       

      I'm trying to build a formula using filters. This is the sample data that I want to work with.

       

      In the formula, I want to compare the value of location AA and CC. How would I build that formula so that I get a value of 2? (Location CC =3 - Location AA =1)

       

      Thanks!

       

      LocationValue
      AA1
      BB2
      CC3