AnsweredAssumed Answered

Summary Field Control?

Question asked by disabled_morkus on Feb 9, 2016
Latest reply on Feb 10, 2016 by disabled_morkus

Say you have the following data, which represents the difference, in days, between a ship date and a receive date:

 

1

2

3

0  --> Not yet received

5

 

Now, it seems that if I use a Summary Average field, for example, FM would take the sum and divide by 5, which isn't what I want (should be divided by 4 since the 0 means I haven't received the item yet.).

 

I realize FM won't understand my 0 to mean "don't include", but I don't see any way to tell the Summary Field Function to ignore a value based on some rule (an if statement, for example).

 

So, my options that I know about would be to create a script where I control how the average computes and do the calculation manually using some trigger?

 

----

 

Is there a built-in FM function that would do this calculation where I can configure how the calculation happens like I can with a regular calculated field? Not sure how to handle this situation.

 

I did check the documentation, but possibly missed a better way to do this.

 

Thanks in advance,

 

- m

Outcomes