Expand my Community achievements bar.

subtract project total budget from planned expense costs

Avatar

Level 2
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})
5 Replies

Avatar

Community Advisor

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.

 

 

 




Avatar

Community Advisor

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?




Avatar

Level 2

YES!

 

This Worked !!!

 

AMAZING THANK YOU SO MUCH!

Avatar

Community Advisor

Great to hear James. Would you mind marking this as resolved.