Display calculation within portal that does not come from a field
I am using FMP ver 11.0 with an external ODBC data source to a MySQL database. In one of my layouts I have a portal that shows multiple records for a certain date. For two of the fields, lets say f1 and f2, I want to have a ratio and display it on the same line within my portal. I don't have the permissions to add fields to the mysql table where these fields come from so I can't store the calculation. Is there a way to display the records in my portal like this:
row1 | f1 | f2 | f1/f2row2 | f1 | f2 | f1/f2
where values for f1 and f2 are different for each row?
Merged variables don't seem to work as it displays the same value for all records. Maybe I am doing it wrong. Any ideas on what else I could try? Any help is appreciated.