0 Replies Latest reply: Sep 21, 2017 9:00 AM by gaurav gopale RSS

    On selection the Value becomes zero

    gaurav gopale

      Hi all

       

       

      I have the following expression in the table along with some dimensions

       

      sum(

      {<

      [Quota.VALIDFROM]={">=$(=MonthStart(date(min([Cost_RLP.CalMonth_New]))))"}

      ,

      [Quota.VALIDTO]={"<=$(=MonthEnd(date(Max([Cost_RLP.CalMonth_New]))))"}

      >}

      [Quota./BIC/K_QUOTE] )

       

       

      The above expression is giving the output

       

      but if i click one of the dimension in the table ,the table show zero values.

       

      before selection

      beforeselection.PNG

       

      After Selection for Code  the value becomes zero.

       

      After selection filter.PNG

       

      After selection.PNG

       

       

       

      Can anyone help me in this.

       

      thanks in advance