7 Replies Latest reply: Aug 19, 2016 10:26 AM by Stuart Frew RSS

    Set Analysis / variable

    Stuart Frew

      Hi holks,

       

      I want to be able to use some set analysis in a text box but instead of sum of Sales of whatever I want to call a variable

       

      This is what I have in my text box

      =num(sum({<CURRENT = {1},MOBILE = {1}>} vHeatMetric),'###########,###')

       

      This is what is in vHeatmetric

      =if((vHeatGetListbox)='Email',$(vEx_Op_EMAIL),if((vHeatGetListbox)='Mobile',$(vEx_Op_MOBILE),0.00))

       

      Within vEx_Op_EMAIL for example we have this:

      count(distinct{$<Email_Flag={'1'}>}  CUSTID) / count( DISTINCT  CUSID)

       

      Right now the text box is giving me the result of vEx_Op_EMAIL but is basically ignoring the set analysis part

       

      Thanks

      Stuart