Need a field to be used for summarizing, distinct counts?

(0) Share

Report

Posted on by JonesEA_2018

250

Hello,

In Dynamics 365 do you have to create a field set to the value of 1 to be used for summarizing and counting in reports? I have several reports that have to be recreated and many of them used a "power of one" field for summarizing and distinct counts. I haven't quite gotten into reports yet so while I'm still creating fields if I need those I can just include them upfront.

Thanks!

All responses (2)

Answers (0)

JonesEA_2018 250 on at

Like (0)

Report

RE: Need a field to be used for summarizing, distinct counts?

Thanks for the response, Adrian.

SSRS is a separate package, right?
Suggested answer

Adrian Begovich 1,019 Super User 2025 Season 1 on at

Like (0)

Report

RE: Need a field to be used for summarizing, distinct counts?

Hi JonesEA_2018,

You do not need to do this as you can display this information in a SQL Server Reporting Services (SSRS) report.