Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2020, 12:28 AM
Mohamad Hachoui Mohamad Hachoui is offline Custom field (%age complete) formula returning error Windows 10 Custom field (%age complete) formula returning error Office 2013
Novice
Custom field (%age complete) formula returning error
 
Join Date: Sep 2019
Posts: 1
Mohamad Hachoui is on a distinguished road
Default Custom field (%age complete) formula returning error

Greetings,

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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting the % Symbol in a Custom Field's Formula perdu2 Project 0 03-14-2018 02:08 PM
Custom field (%age complete) formula returning error COUNTIFS returning Value Error ubns Excel 1 04-16-2015 02:00 PM
Dependency mapping using custom field - formula help alexRP Project 3 03-24-2014 08:03 AM
Custom field (%age complete) formula returning error Custom field formula not working at summary task level abw1987 Project 3 10-05-2011 07:17 AM
Runtime error 5487 - Word cannot complete the save to to file permission error franferns Word 0 11-25-2009 05:35 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft