8 Replies Latest reply: Dec 9, 2016 11:53 PM by Michael Cox RSS

    Help with how to use set P() or E() modifier with variable

    Michael Cox

      Dear Commnity

       

      I have the following set selection formula:

       

           Sum({$ <[Period]= {'=$(=$(vCP))'}  >} [Hours])

       

      It correctly applies a selection to include data where Period = vCP, where vCP is a variable containing the current period.

       

      What I have been unable to achieve is the following: I want to

      a) disregard any selections on Period made by the user (ie is should only show Period = vCP) and

      b) apply any other selections on other fields (eg city, group etc).

       

      I think this is achieved through P() or E() but I cannot fathom how to incorporate with the use of the variable.

       

      Any suggestions?