Hi everyone,
I need help to solve a problem that I faced.
I have a data table:
| Validate Month | Forecast Month | Value |
|---|
| 6 | 6 | 885,20 |
| 6 | 7 | 1.528,19 |
| 6 | 8 | 7.529,00 |
| 6 | 9 | 8.014,50 |
| 6 | 10 | 5.014,50 |
| 6 | 11 | 5.514,50 |
| 6 | 12 | 2.514,50 |
| 7 | 7 | 1.500,00 |
| 7 | 8 | 6.377,41 |
| 7 | 9 | 6.788,66 |
| 7 | 10 | 4.247,52 |
| 7 | 11 | 4.671,04 |
| 7 | 12 | 2.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 Month | Forecast Month | Value |
|---|
| 6 | 7 | 1.528,19 |
| 6 | 8 | 7.529,00 |
| 6 | 9 | 8.014,50 |
| 7 | 8 | 6.377,41 |
| 7 | 9 | 6.788,66 |
| 7 | 10 | 4.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.
