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

    Complicated Addition




      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


      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)


      and not


      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?