Click here to Skip to main content
15,892,797 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
(SUM(Fields!minutes.Value) * Parameter!pworkstation.Value) / Parameter!ptotal.Value)

What I have tried:

(SUM(Fields!minutes.Value) * Parameter!pworkstation.Value) / Parameter!ptotal.Value)
Posted
Updated 14-Dec-20 19:39pm

1 solution

Your query is not too clear right now. But, it does point that you are looking at using aggregate functions in RDLC and need to know how to use them.

It's always a good idea to look at the documentations for basics:
Lesson 6: Adding Grouping and Totals (Reporting Services) - SQL Server Reporting Services (SSRS) | Microsoft Docs[^]
Aggregate Functions Reference (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs[^]
Add a Moving Average to a Chart (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs[^]

Try out.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900