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

kaanerisen — Mon, 27 Nov 2017 07:27:04 GMT

Hi everyone,

I need help to solve a problem that I faced.

I have a data table:

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:

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.

topic Table doesn't calculated if more than one field value selected in App Development