Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Below is my sample data.my requirement is if the end user selects a month,I want to display that month data and also data which is not associated to any month.(ex:if end user selects JAN then that should display JOBS 1,5,7).Any help is appreciated
JOB | MONTH | RESULT |
1 | JAN | 10 |
2 | FEB | 15 |
3 | NOV | 11 |
4 | DEC | 35 |
5 | NA | 60 |
6 | MAR | 0 |
7 | NA | 0 |
maybe
only({$ <MONTH+={NA}>} RESULT)
Thanks for your response,Actual data is NULL in the place of NA.Can you tweak that logic for NULL
only({ 1-<MONTH={*}>+<MONTH=P(MONTH)> } RESULT)