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
  • 1441 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 and Adobe Champion
KellieGardnerCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
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 and Adobe Champion
    KellieGardnerCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    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...