Performing Calculation Across Rows Conditionally

[TimeTravel_0]

I have a table with 3 fields, one of which is an ID that the data is grouped by.  What I want to do is use the other fields to perform a calculation based on their values. So the fields I have are ID, Price, and New_Price. I want to perform the logic: if isNull([New_Price]) then [Price] else [New_Price] endif across all records, and have the field names for this formula be based on ID: "Final_Price_ID1", "Final_Price_ID2", ... , "Final_Price_ID28".

Thanks,

Time_Travel_0

[TimeTravel_0]

@MSalvage ,

This looks like it is working, however it is not doing more than 9 prices, even after I added the \d+

It is doing exactly 9.

[MSalvage]

@TimeTravel_0,

Did you add it in the parenthesis?

Best,

MSalvage