5 Replies Latest reply on Apr 27, 2011 10:36 AM by MariamAbdulqader

    Display calculation within portal that does not come from a field

    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.