You need to sign in to do that
Don't have an account?
SBN
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
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
Can you verify if there is any value "Exchange Number" field, as formula is correct. Try to check for different records.
I tried the formulae with ISBLANK also but still not working