When creating a calculation in FileMaker, things can get quite complicated. You may need to use a range of sub-expressions with nested FileMaker functions. The resulting calculation expression may work