9 Replies Latest reply: Dec 8, 2015 1:44 PM by Sangram Reddy RSS

    Expression not working in KPI or Text measure

    lakwinder singh

      Hi Guys,

       

      This works in a table, but do you know why it doesn't work in a KPI or Text measure?

       

      Sum({1<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ)

      /

      Sum (total{1<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ)

      -

      Sum({1<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ)

      /

      Sum(total{1<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ)