1 Reply Latest reply: Sep 22, 2017 12:49 AM by Shraddha Gajare RSS

    On selection the value gets 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