I have written the following but each time I apply, the system automatically creates new rows. I am sure the answer is simple here so I'd appreciate the advice. All I am looking to do is multiple the [Multiplier] by the [Gross Amount].
Country & Category as [Key Indicator],
[Multiplier + Recovery] as [Multiplier]
[ISO] & [CATEGORY]as [Key Indicator]
[GROSS AMOUNT]*(ApplyMap('TableMapping',[Key Indicator],'missing')) as Multiplier