4 Replies Latest reply: Sep 22, 2016 7:37 AM by Eric Hetem

Set Analysis Operator: link 2 fields

Eric Hetem Sep 19, 2016 3:15 PM

Is it possible to use the following in a set analyse ?

Aim is to neglect the value(s) selected for the [Schedule quater], but instead use the value(s) for the field [close quarter]

Sum( {$< [Schedule Quarter]=, [Close Quarter]=[Schedule Quarter] >} [Sales])

Re: Set Analysis Operator: link 2 fields

Stefan Wühl Sep 19, 2016 3:26 PM (in response to Eric Hetem )

This could work, at least the syntax is ok, have you tried it?
Like Show 0 Likes (0)

Actions
- Re: Set Analysis Operator: link 2 fields
  
  Eric Hetem Sep 22, 2016 7:37 AM (in response to Stefan Wühl )
  
  I tried and it didn't work
  
  Like Show 0 Likes (0)
  
  Actions
Re: Set Analysis Operator: link 2 fields

Sunny Talwar Sep 19, 2016 3:28 PM (in response to Eric Hetem )

Or may be this:

Sum({$<[Schedule Quarter]=, [Close Quarter] = p([Schedule Quarter])>} [Sales])
Like Show 0 Likes (0)

Actions
- Re: Set Analysis Operator: link 2 fields
  
  Eric Hetem Sep 22, 2016 7:37 AM (in response to Sunny Talwar )
  
  This is perfect.
  Thx
  
  Like Show 0 Likes (0)
  
  Actions