function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
liron169liron169 

SF Standard Report

Hello,
Need advise please, if below funcionality can be done with SF standard reports (perhaps join report? ).

Assume I have 3 objects:
Object A
Object B (child of A)
Object C (child of A)

I need excel Report with the following columns:

(1)A.name 
(2)Total B records where B.name='X'
(3)Total B records where B.name='Y'
(4)Total C records where C.name='M'
(5)Total C records where C.name='N'

of course, it can be done, by creating roll-up summary fields on the main object.
The question is if it can be done without - means the calculations of the total will be done in the report?

Thanks.
SANKAR NSANKAR N
Hi,

 You can use formula in summary reports , In Report formula you can sum of grouped records. 

 But, you want to count based on some conditions.. I don't think so it's possible in reports.