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?