6 Replies Latest reply: Nov 15, 2017 2:29 AM by Tresesco B Branched to a new discussion. RSS

    Logic Help in opportunity caliculaton?

    Ganesh Reddy

      Hi All,

       

      I have two sheets in attached QVW, In the first sheet view/report all metrics are giving us the correct results, where as in second sheet/ report the highlighted Total GWP of opportunity and current participation values are incorrect due to used expressions, PFB used expression.

       

      Sum({<TransType={'T'}, MarketName=>} if(substringcount(POLICYMARKET, '$(vSelectedMarket)')=0, [GrossWrittenPremium_GBP], 0))


      According to requirement in the place of used variable 'vSelectedMarket' we need to pass respective dimension value for each row in the report, and I am unable to pass that respective dimension value.

       

      can any one suggest me the correct expressions or help me to create logic in script level?

       

      Thanks,

      Ganesh