This is one of those things that should be incredibly simple, yet I can't ever seem to do it. I want to build a report where I can get subtotal counts of rows containing a date/time stamp. So for the example below, I'd like to see subtotals for these 3 columns (should total 6, 6, and 1). I have tried working with summary formulas, but the only thing you can do with them is count unique dates, which as you can see, won't work. Any ideas?
1 answer
HI Michael,
There's only 1 thing I can think of and it woudl be to create 3 formula fields on Campaigns or Campaign Members:
IF(ISBLANK(FirstRespondedDate),0,1)
IF(ISBLANK(MQLDateStamp__c),0,1)
IF(ISBLANK(SQR_Qualified_DateStamp__c),0,1)
Make sure you select "treat blnak fields as blank" for the 3 formulas.
You can now use these formuals in your report to have a count
