Show financial values in project properties

[Nei RGlhcyBWaWxsYXMgQsO0YXM=]

Hi Communitie!

 

We need following information  at project´s propertie page:

 

Actual Cost.........................................: ok = I have created a calculated attrib Sum(aggr_actual_cost) to show total realized. 

Cost total............................................: ok = Already exist in Clarity  [Planned Capital Cost] to show total planned cost.

Actual Cost - Current Year.....................: ? = We need to know how much project spents in current year.

 

So, how can I put this ACTUAL COST  - CURRENT YEAR in project´s propertie page?

Looks like a query solution, but in this case I am afraid for database performance issues.

 

Best regards,

 

Nei Villas Boas

[Anon Anon]

Does this help ; TIP : How To Put Any Dynamically Generated Value On A Clarity Object

[Nei RGlhcyBWaWxsYXMgQsO0YXM=]

Hi Dave,

 

It will be a challange due my low SQL skill, but maybe this is the only way to do it.

I am still concerned about performance issue, so I will use a TEST environment.

Thank you very much for your useful input.

 

Best regards,

Nei