6 Replies Latest reply on Jun 11, 2018 8:37 AM by Jim Dehner

    Calculation with filters applying to one field only

    Patricia Martin

      Hello all,

       

      I hope you can help me with this.

      I need to create a calculation for CPA = Cost / Total Conversions.

      The problem I have is that I need to create this calculation in a way that a filter only affects Total Conversions and it doesn't affect Cost field.

      I can't use parameters because the filter I am applying can contain multiple values.

       

      I tried to duplicate the data source but I didn't manage to make it work.

       

      Hopefully, you guys can give me a hand with this! :-)

       

      Thank you so much in advance!

       

      Patricia