Skip to main content
Question

HOW To Create a sub total for Project Cost on All Activity in Project

  • August 21, 2020
  • 1 reply
  • 191 views

Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 5 replies

I äm trying to create a new lobby for Project Hour and Cost Analysis hence I have created the below sql query but I am finding it difficult to have a sub-total for every group of the same activity

I wrote the following SQL query 

 

select distinct

a.activity_description,

a.resource_id as resource_id,

b.resource_group_desc,

a.qty_used as qty_used,

a.qty_planned as qty_planned,

a.project_cost,

a.percent_used

from IFSAPP.activity_resource_proj a JOIN IFSAPP.activity_resource_proj_sum b

ON a.resource_id = b.resource_id

AND a.project_id = '&Project_ID'

ORDER BY activity_description

 

Below is what I am gettting:

I need a sub_total for Activity named 'DETAILED DESIGN’ as well as sub_total for '’ÍNSTALLATION SAFETY STUDIES'’

 

 

1 reply

EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • 181 replies
  • March 16, 2021
DAVIDO wrote:

I äm trying to create a new lobby for Project Hour and Cost Analysis hence I have created the below sql query but I am finding it difficult to have a sub-total for every group of the same activity

I wrote the following SQL query 

 

select distinct

a.activity_description,

a.resource_id as resource_id,

b.resource_group_desc,

a.qty_used as qty_used,

a.qty_planned as qty_planned,

a.project_cost,

a.percent_used

from IFSAPP.activity_resource_proj a JOIN IFSAPP.activity_resource_proj_sum b

ON a.resource_id = b.resource_id

AND a.project_id = '&Project_ID'

ORDER BY activity_description

 

Below is what I am gettting:

I need a sub_total for Activity named 'DETAILED DESIGN’ as well as sub_total for '’ÍNSTALLATION SAFETY STUDIES'’

 

 

Hi @DAVIDO ,

I think best solution would be to go for an IAL and use it in the lobby.

You can get the total for each activity that way. Hope you are familiar with IALs.

Regards,


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings