Solved
GetRecords Formula Help
Looking for assistance to help figure out why my formula isn't working as expected. Setup: Rental Rates table: used to capture the Daily, Weekly, and Monthly rental amounts for Assets. There is a l...
Got it to work using:
SumValues(GetRecords("{13.EX.'"&[Asset Tag ID]&"'}AND{14.EX.'"&[Rental Year]&"'}",[_DBID_RENTAL_RATES]),8)
Removed the GetFieldValues parameter and replaced with SumValues. That at least got rid of the error and returned a value. The value was wrong-ish. It was retrieving values but not for the intended record, had to change the comparison fields, once I did it is now pulling the correct values.
