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
SBNSBN 

Report Formulae not Working

Hi,

I created a Summary report and grouped by "Exchange_Number__c". I added a Custom formulae below.

IF(ISNULL(Contact.Exchange_Number__c), RowCount, NULL)

The formulae is returning the row count even though there is value in  "Exchange Number" field. I want to show the row count only when there is no value stored in "Exchange_Number__c" field .

Can anyone look at the above formulae and let me know whats wrong in this.

Thanks
Vinita_SFDCVinita_SFDC
Hi,

Can you verify if there is any value "Exchange Number" field, as formula is correct. Try to check for different records.
SBNSBN
Some of the values in the records in that field are Numbers  and some of them are blank....
I tried the formulae with ISBLANK also but still not working