Total Cost

[Shpilmaa]

Hi guys,

i have a table with cost and qty that changed every time, for example:

Cost 179 and qty 2 or 3 (it can be any number)

i want to make a report with bar chart for total cost, how can i make it?

thanks for advance!

[Sainath N]

@Shpilmaa : Please try the below combination of conditions to achieve your requirements. As I am not sure on the table that you are reporting, I tried with the alm_asset table, which has similar fields like cost and quantity. Below is the report that gives the total cost of the assets grouped by model categories.

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

[Shpilmaa]

Exactly what i did

the table i use is (sm_asset_usage)

and in bar chart i got sum 81$ instead of 129$

[Sainath N]

@Shpilmaa : Could you make sure that you are using the right fields for aggregation? I see that you are grouping on different fields and aggregating on different fields (do the Service Order Task.Asset.Model and Model fields hold the same value?). Using these conditions in my PDI, I get the exact count in both the list and the report.

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

[Pradnyesh]

Hello @Shpilmaa 

Do the configurations as per below attached photo.

Please mark this as helpful 👍 if it resolved.