Skip to main content
Question

How to multiply all the record values of a Field?

  • May 18, 2018
  • 0 replies
  • 122 views
Field1     Field2
1             3
2             5
3             7
4             2



I need to do 3*5*7*2=210
And I want to show the result as


Field1     Field2       Field3 
1             3               210
2             5               210
3             7               210
4             2               210


I'm able to figure out the way to make Multiplication possible. Please Help.
      This topic has been closed for replies.

      You will need to create a new table in the app with a single record in it. It will be Record ID 1.


      Then make a formula on your details table of 1 and make a relationship.


      Then make a sum of a field which multiplied the two numbers.


      That is called the �dot product�.

      https://en.m.wikipedia.org/wiki/Dot_p...
      • anomDiebolt
      • Registered
      • May 18, 2018
      Follow these steps:
      1. Create a field Ln([Field2]) in the child table (your existing table)
      2. Summarize this field to the parent field named [SumLog] using addition
      3. Create a formula field in the parent  table named [Product] and set it equal to the formula Exp([Product])
      4. In the child table lookup the field [Product] from the parent
      This works because Law of Logarithms:

      3 * 5 * 7 * 2 = exp( ln(3) + ln(5) + ln(7) + ln(2) )= 210

      Then go watch Standard Deviants:

      Standard Deviants: Pre-Calculus Module 6 - Logarithms
      https://www.amazon.com/Standard-Deviants-Pre-Calculus-Module-Logarithms/dp/B000A2EKTA
        Thanks guys, it's working. Learnt new thing today. 
        Terms & ConditionsAccessibility statement