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:





0  --> Not yet received



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