5 Replies Latest reply: Mar 3, 2017 7:32 AM by Priyanka Sawant RSS

    How to use variable in a Set Analysis

    Haikuo Yu

      The following Set Analysis works.

      Sum( {$<[login pass Last Access]={'Feb-17'}>} [login pass Total])

      However, I create a variable for field [login pass Last Access] as vLoginPass,

      when using the following Set Analysis with the above variable, not working any more

      Sum( {$<[login pass Last Access]= {'$(=vLoginPass)'} >} [login pass Total]) , not working

      Sum( {$<[login pass Last Access]= {'$(vLoginPass)'} >} [login pass Total]) , not working

      Any suggestion is appreciated!