Hi All,
I have a requirement to cap the values >=vmin and<=vmax, so in case it is just the capping of a number greater than vmax i would use ragemax or ragemin as expected but here i need to do it both the ways.
For eg:
My dataset is as below:
and I want to create a table with expected col like below:
| Dim | Val | Expected |
| A | 10 | 20 |
| B | 54 | 50 |
| C | 32 | 32 |
| D | 85 | 50 |
| E | 12 | 20 |
| F | 65 | 50 |
where vmin=20 and vmax=50
Could anyone please help me on the same.
Values of vmin and vmax are dynamic and shall change based on user input
Attached a sample for the reference
