2 Replies Latest reply on Nov 18, 2016 5:46 AM by Rob Rimmer

    Varying measure used in T/F expression through parameter?

    Rob Rimmer

      Hi,

       

      I want to be able to let my dashboard users compare the marketing source make-up of our contact centre leads using a variety of different timescales. The table I'm using (not my table, created by our BI guy) has T/F fields on each line for time periods such as Current Month (CM), Previous Month (PM), Last 3 Months (3M) etc. I have created 2 parameters with the names of those measures in; one for each part of the comparison i.e. CM vs 3M. I have tried creating the expression below, but encounter an error that says I can't use 'boolean' type in IF statement.

       

      Does anyone know how I get round this? I need to measure to pull into another expression that checks whether it is True or False...

       

      Thanks in advance.