subtract project total budget from planned expense costs

[JamesCh6]

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})

[KellieGardner]

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.

[JamesCh6]

the native field would not calc either. 

[KellieGardner]

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?

[JamesCh6]

YES!

This Worked !!!

AMAZING THANK YOU SO MUCH!

[KellieGardner]

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