subtract project total budget from planned expense costs | Community
Skip to main content
J
JamesCh6
Level 2
February 2, 2024
Question

subtract project total budget from planned expense costs

  • February 2, 2024
  • 1 reply
  • 759 views
I am trying to get a  calc field to show my total project budget minus expenses. I do not want to include taks/hours/etc.
 
SUB({DE:Tech Services - Total Project Budget},{plannedExpenseCost})
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
February 2, 2024

Your total project budget is a custom field? not the native budget field in Workfront? 

 

The formula you have *should* be correct but it might be something with your custom field name if you aren't getting a returned value.

 

 

 

J
JamesCh6Author
Level 2
February 2, 2024

the native field would not calc either. 

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
February 2, 2024

I have this field on my reports that works.

 

displayname=Cost Remaining
linkedname=direct
textmode=true
valueexpression=SUB({budget},{plannedExpenseCost})
valueformat=currencyStringCurrencyRounded

 

Do both the budget fields and planned Expense fields return values when you do them separately in a column?

    Terms & ConditionsAccessibility statement

    Loading footer...