Compare two table fields on a Report: Greater than Field

Alphons
Tera Contributor

I want to see my projects which are over budget with: field Actual cost Greater that field Budget Cost.

However I cannot select the field Budget Cost from a list, instead I type it in a textbox, but that doesn't work and it creates a very strange syntax, see the upper highlighted line in the picture.

 

What syntax do i need to use for the Budget Cost?
Or is there something wrong with the report conditions?

 

Thanks for helping me,

Fons.

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

You need to use the technical name: budget_cost. It will show up then.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

4 REPLIES 4

Mark Manders
Mega Patron

You need to use the technical name: budget_cost. It will show up then.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Alphons
Tera Contributor

Thank you, this works for projects.

 

For Demand, is there a different technical name for budget_cost, because on the Table: Demand [dmn_demand] this does not work.

 

Thank you.

I checked on an OOB instance (on Washington), but there is no 'budget cost' on the demand table. The only 'budget' fields I have are 'capital_budget' and 'operational_budget'. You could check the technical name of the field you are trying to compare by looking at the XML of a demand record, or checking the dictionary. 
If you don't have access to those, ask one of the admins to validate the technical name of the field for you.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Thank you Mark, I checked with our admins, the provided the technical name.
It appears to be custom field. 

Best Regards.