- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-07-2024 04:15 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-07-2024 05:40 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-07-2024 05:40 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-07-2024 06:25 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-07-2024 11:05 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-07-2024 11:47 PM
Thank you Mark, I checked with our admins, the provided the technical name.
It appears to be custom field.
Best Regards.