0 Replies Latest reply: Nov 27, 2017 2:27 AM by kaan erisen RSS

    Table doesn't calculated if more than one field value selected

    kaan erisen

      Hi everyone,

       

      I need help to solve a problem that I faced.

       

      I have a data table:

       

      Validate MonthForecast MonthValue
      66885,20
      671.528,19
      687.529,00
      698.014,50
      6105.014,50
      6115.514,50
      6122.514,50
      771.500,00
      786.377,41
      796.788,66
      7104.247,52
      7114.671,04
      7122.129,90

       

      What I need is:

       

      User can define a forecast look up month by using variable. For example if the user select 3, then the table above should look:

       

      Validate MonthForecast MonthValue
      671.528,19
      687.529,00
      698.014,50
      786.377,41
      796.788,66
      7104.247,52

       

      I achived this by using this expression, but it works only one validate month is selected.

       

      Sum({<[Forecast Month]={"=[Forecast Month]>[Validate Month] and [Forecast Month]<=[Validate Month]+$(vMonthLookUp)"}>}Value)

       

      I attached a sample app. Any support anyone can provide is appreciated. Thank you.