AnsweredAssumed Answered

Complicated Addition

Question asked by BradKnewstubb on Jul 20, 2016
Latest reply on Jul 20, 2016 by user19752



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?