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
Solved! Go to Solution.
@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.