10 Replies Latest reply: Feb 9, 2017 2:57 AM by Mohammad Sarif RSS

    Dynamic Dinominator

    Mohammad Sarif

      Hi All,

       

      I have denominator in division calculation like below:

       

      RangeSum(Value) /

      ((4*Count (distinct PLANT)) - Count({<Dates1 = {"$(=Date(Date#('$(vDATE)','M/D/YYYY') - 7))","$(=Date(Date#('$(vDATE)','M/D/YYYY') - 14))","$(=Date(Date#('$(vDATE)','M/D/YYYY') - 21))","$(=Date(Date#('$(vDATE)','M/D/YYYY') - 28))"} >}Dates))


      But my chart is behaving wrongly. However If we plot the same expression of denominator in Single KPI, it returning a correct numeric value.

      Can you please help.

       

      Thanks,

      Sarif