displayname=Portfoliolinkedname=projectnamekey=view.relatedcolumnnamekeyargkey.0=projectnamekeyargkey.1=portfolioNamenamekeyargkey.2=namequerysort=project:portfolioIDtextmode=truevaluefield=project:portfolioID:namevalueformat=HTML

Can this also be done to convert a Portfolio ID to a Portfolio Name?

project report

okay very helpful. Where can I find the predecessor for an expense object? Here is the winning formula: SUB({project}.{budget},{DE:Tech Services - Actual Spend})  next steps is calculating all of these expenses into a new total that can be viewed in a summary.  

they are all set to currency

Hi, Here are the columns with their expressions:Column 1 - Project Budget - {budget} - this is the native field for the overall project budgetColumn 2 - Actual Amount Remaining - SUB({plannedAmount},{DE:Tech Services - Actual Spend})Column 3 - Tech Serv PE v PB - SUB({budget},{DE:Tech Services - Per...

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...

  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 

YES! This Worked !!! AMAZING THANK YOU SO MUCH!

the native field would not calc either.