I'm trying to inflate the values by a % for certain records in the data. I'm trying to do this using the Multi-Field formula. But The values are
ID | Modifier | Payor1 | Payor2 | Payor3 |
1 | 51 | 347 | 3466 | 523 |
2 | 5457 | 3474 | 3468 | |
3 | 54 | 589 | 800 | 790 |
I need to inflate the values by 150% for Payor1,2 and 3 if the modifier is 51 and by 120% for Modifier 54 ELSE No change to the values. In the above example rows with ID 1 and 3 have to be inflated. I tried this below formula but its not correct.
IF [Modifier]=51 THEN [Payor1]=[Payor1]*1.5 ELSE 0 AND [Payor2]=[Payor2]*1.5 AND [Payor3]=[Payor3]*1.5
ELSEIF [Modifier]=54 THEN [Payor1]=[Payor1]*1.2 ELSE 0 AND [Payor2]=[Payor2]*1.2 AND [Payor3]=[Payor3]*1.2
ENDIF
Solved! Go to Solution.