SUB ({budget}, {Actual Expenses}) Native - calculated | Community
Skip to main content
J
JamesCh6
Level 2
February 6, 2024
Question

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

  • February 6, 2024
  • 1 reply
  • 1439 views

 

 

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

 

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 6, 2024

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

 

SUB({budget},calculated column expression)

 

 

 

    J
    JamesCh6Author
    Level 2
    February 7, 2024
    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
    KellieGardner
    Community Advisor
    KellieGardnerCommunity Advisor
    Community Advisor
    February 7, 2024

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

    Terms & ConditionsAccessibility statement

    Loading footer...