2 Replies Latest reply on Nov 11, 2015 6:35 AM by doumlegare

    Portal row calculation multiply

    doumlegare

      Hello,

      I looking for help to create a calculation inside my portal row.

      I want to multiply Quantitie (3rd colum) x Quantite (5th column) in the calculation field in QuantiteTotal (last column.)

      Quantitie (3rd colum) are set in an other table

      Quantite (5th column) are set in that table


      thank you for your help

      Sans titre.jpg

        • 1. Re: Portal row calculation multiply
          steveromig

           

           

          Hello,

          I looking for help to create a calculation inside my portal row.

          I want to multiply Quantitie (3rd colum) x Quantite (5th column) in the calculation field in QuantiteTotal (last column.)

          Quantitie (3rd colum) are set in an other table

          Quantite (5th column) are set in that table


          thank you for your help

          Sans titre.jpg

           

          In the related table you simply need to create a calculation field (I'll call it CalcField1) that multiples the two fields together.

           

          CalcField1 = Quantitie * Quantite

           

          Since you are using a related field from a related table and local field from a local table you simply use the field from the local table instead of the one that is from the related table.  In other words, something like...

           

          CalcField1 = RemoteTable::Quantitie * LocalTable::Quantite

           

          Steve Romig

          FileMaker, Inc.

          • 2. Re: Portal row calculation multiply
            doumlegare

            Thank you for your fast reply

            I thing my calculation si good ,it's seems to work on line 1 but in the portal row it seems that don'T want to work.

            Do i have to create a relationship ? or something else

            thank you

            Sans titre1.jpg