4 Replies Latest reply: May 8, 2012 10:03 AM by Jose Tos RSS

    How do you write an expression with a modifier between x and y values?

    Kathryn Brown

      Hi

       

      =sum({1<Area={'UK'}, Contractor={0},Op_Week={">=$(=$(vMaxCompleteOpWk)-4)"} >} [Issued])
      /sum({1<Area={'UK'}, SubcontractorType={0},Op_Week={">=$($(=vMaxCompleteOpWk)-4)"}>}  Declared)
      
      

       

      I am trying to write an expression based on the one below to return data where the Op_Week is between vMaxCompleteOpWk and vMaxCompleteOpWk-4.  Any help would be welcome

       

      Thanks