3 Replies Latest reply: Aug 12, 2011 4:42 AM by Jeroen Veldhoen RSS

    Set analysis based on multibox selection

    Jeroen Veldhoen



      I am making use of a set analysis function for an expression. A field 'name' can be selected by a multibox, but does not always have a selection. I would like to base the set analysis on the selection of 'name' in the multibox, ONLY when there are one or more names selected.


      So the set analysis looks like:

      sum({< name=, eng_partner_name={name}, eng_costcenter_key = {$(vCostCenter)}, emp_level = {'junior'}>} timeAmount)


      The current problem with this set analysis is that none of the 'eng_partner_name' records are selected when there has been no selection on the multibox.


      How to get this fixed?? I prefer to avoid if functions.