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개
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
