Skip to main content
Question

Using Project Attribute Fields to Calculate PO Balances

  • April 24, 2025
  • 2 replies
  • 90 views
  • Translate All

 

Hello,

Is it possible to use project attribute fields to calculate our project purchase order (PO) balances? I’m trying to sum the ORIGINPO and COPO attributes in one GI column.

 

In a separate column, I attempted to subtract this sum from the project billed amount. However, I received an error stating:

“The virtual field originpo_attributes cannot be used in a condition expression.”

 

 

Is there another method I should use to achieve this?

 

 

 

 

2 replies

I made additional changes to this GI to help visualize what I’m trying to accomplish. However, I’m stuck on creating a calculation for (Original PO Value + Change Order Value) – (Billed Total + Credit Memo Total). I receive the same error message when I include the project attribute fields. 

 

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img

Hi ​@benkleyla80 were you able to find a solution? Thank you!

Translate