13 Replies Latest reply: Oct 14, 2011 1:57 PM by Stefan Wühl RSS

    Set analysis zero values if no selection is made

    Jen Starr

      I'm trying to get a count of all publications, that a customer in the USA has access to, which are located in the customers state, base on a date range. If a customer is selected, then I get the results I need.  If a customer is not selected, then the result is zero.    Count({=$(=(vPivot_StartDate))<$(=date(vPivot_Date))"},[PUB USA or International]={USA},[CAM USA or International]={USA},[CAMS_State]={"=PUB_State=CAMS_State"}> } DISTINCT(pubid)) I would like to be able to see both a result for all USA customers that use in-state publications as well as the individual customer results as well.  Thanks, Jen