I am using a multi-row transformation, but I cannot seem to get the IF statement correct, hoping someone can help me out.
Here is the incoming data:
Count Total
3 3372.08
3 245.73
3 3617.81
This is current output:
| Count | Total | Label |
| 3 | 3372.08 | TOTAL INVOICED PREMIUM |
| 3 | 245.73 | TOTAL INVOICED PREMIUM |
| 3 | 3617.81 | TOTAL INVOICED PREMIUM |
Need it to be:
| Count | Total | Label |
| 3 | 3372.08 | TOTAL INVOICED PREMIUM |
| 3 | 245.73 | INVOICED NO DEDUCTIONS |
| 3 | 3617.81 | TOTAL INVOICE |
Here is my logic in the Multiple Row tool:
IF [Row-1:Count] = 3 then "TOTAL INVOICED PREMIUM"
ELSEIF [Row-1:Count] + 1 = 3 then "INVOICED NO DEDUCTIONS"
ELSEIF [Row-1:Count] + 2 = 3 then "TOTAL UNUM INVOICE"
else 0
ENDIF
Any help is greatly appreciated :-)
