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)
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?