Forum Discussion
LOOKUPVALUE or another formula?
Good day, I am trying to create a caluclated column, which pulls in a value "conversion rate" from a currency conversion rate table, based on a specified date, and the currency code (Cdn, AUD etc...
Hi Anonymous,
Based on error message, it seems like you formula can find out multiple records based on above conditions.
Current calculated column and measures not support stored multiple records, I think you need to modify your formula to cut down the result amount or use CONCATENATE function to merge them to string.
Can you please share some sample data to test? it will be help for troubleshooting your scenario.
Regards,
Xiaoxin Sheng