View Single Post
Old 08-16-2020, 12:28 AM
Mohamad Hachoui Mohamad Hachoui is offline Windows 10 Office 2013
Join Date: Sep 2019
Posts: 1
Mohamad Hachoui is on a distinguished road
Default Custom field (%age complete) formula returning error


We have a custom field calculating the actual %age complete via a formula shown in the attachment. The actual %age = % Complete x Weight (Number1)/100 as shown below. This formula is returning an error each time the file is opened. After clearing any value in the Weights column and reentering the same, the values are shown again.

[% Complete]*[Number1]/100

Any clues please?
Attached Images
File Type: jpg Formula issue.JPG (57.2 KB, 1 views)
Reply With Quote