AnsweredAssumed Answered

Display calculation within portal that does not come from a field

Question asked by MariamAbdulqader on Apr 27, 2011
Latest reply on Apr 27, 2011 by MariamAbdulqader

Title

Display calculation within portal that does not come from a field

Post

Hello,
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. 

Outcomes