1 Reply Latest reply on Jul 22, 2016 10:07 PM by Dmitry Chirkov

    IF statement help

    Mikey Michaels

      Hello All,

      Thank you so much for taking a look at my question!

      I will try to keep this brief and straightforward.

       

      On the attached, I'm trying to display only the Salespersons where their EASy Utilization is less than my parameter [Less than] and they have [Greater than] Number of Records over the last x (another parameter) number of months. The date driver for this calculated field is my [Date parameter].

       

      something like:

      IF [EASy Utilization] is < [Less than] and [Number of Records is > [Greater than] ....I have a hard time finishing the formula when it comes to adding a parameter for the last x number of months.

       

      Any ideas on how to solve?

      Thanks again for the help.

       

      Cheers,

      Mikey