6 Replies Latest reply on Jul 20, 2016 10:31 PM by user19752

    Complicated Addition

    BradKnewstubb

      Hi,

       

      I am having trouble wrapping my brain around how to get filemaker to add up the following.

       

      We manufacture panels for the construction industry however sometimes the required panels are parts of a whole panel. At present we simply specify either a half panel or a whole panel which makes things easy to add up:

       

      0.5 + 1 + 0.5 = 2

      Addition-01.jpg

      I would like to increase our efficiency by allowing us to use a wider variety of decimals to add up the total however this is where I am getting stuck. I need:

       

      0.25 + 0.5 + 0.75 = 2 (r=0.5)

      Addition-02.jpg

      and not

      Addition-03.jpg

      0.25 + 0.5 + 0.75 = 1.5

       

      How do I stop filemaker from adding up values that result in a number higher than 1?