SUB ({budget}, {Actual Expenses}) Native - calculated

11 replies
1504 views
Translate All

attempting to: subtract a calculated column of {actual expenses} from the native project {budget} field.

example: (column 1 "native budget field") - (column 2 "calculated actuals") = column 3

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

KellieGardner

Community Advisor

You would need to include the calculation of your calculated column in the calculation for your third column.

SUB({budget},calculated column expression)

Translate

J

JamesCh6Author

Level 2

SUB({budget},{DE:Tech Services - Period 1 Actual},{DE:Tech Services - Period 2 Actual},{DE:Tech Services - Period 3 Actual},{DE:Tech Services - Period 4 Actual},{DE:Tech Services - Period 5 Actual},{DE:Tech Services - Period 6 Actual},{DE:Tech Services - Period 7 Actual},{DE:Tech Services - Period 8 Actual},{DE:Tech Services - Period 9 Actual},{DE:Tech Services - Period 10 Actual},{DE:Tech Services - Period 11 Actual},{DE:Tech Services - Period 12 Actual})

not returning any values

Translate

KellieGardner

Community Advisor

Hi James - what is your expression for column 2 (Actual Amount Remaining) that is returning a value?

Translate

Sign up

Login with SSO

Login to the community

Login with SSO