AnsweredAssumed Answered

Format on SubSummary Calculations

Question asked by arthurlaurent on Sep 20, 2017
Latest reply on Sep 21, 2017 by arthurlaurent

I'm new at creating functions (and scripts) -- i.e., I still have the book open when I try one, so I apologize in advance for my rudimentary question.

 

I have a sub-summary calculation field called "Average(Words)" which works as expected (Imagine that! Ha Ha Ha), except that my result is a number followed by a decimal and four digits.

 

(I tried using the Inspector to format the calulation/numeric field, but could only get down to two decimal places...)

 

I want  to round (up or down) to get an integer.

 

Could I use the Round function, with a precision of 0, to get what I'm looking for?  Should I create a separate "Round (AveWords;0)" field to display this, or stack "Average" and "Round" commands (a mini-script) in a single field definition, or some other way? What is the best way to do what I want to do?

 

Thanks in advance for any help.

 

Arthur

Outcomes