7 Replies Latest reply: Jul 17, 2014 7:22 AM by Martyn Lloyd RSS

    Set analysis syntax

    Martyn Lloyd

      I have an expression:

      ({$<Domain={'Sales'}, [Dealer Type]={'SSP'}, [KPIID]={'S10','S11A','S11B'}, KPIYear={2013, 2014}>} Result)

      I have a field CurrentYear, and I want to use CurrentYear-1 and CurrentYear instead of the fixed values, please can you help me get the correct syntax?