AnsweredAssumed Answered

Complicated Addition

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

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?

Outcomes