remove null & empty values
I created a report with multiple fields. I would like to create a generic formula in which it evaluates all the values and if it found a null or empty value it will be replaced by a 'N/A'. I was searching in the forums and I found the following formula
if (isnull() or ( ='')) then
"Display the required text"
when I tried to use it i had an error that the value must be boolean. Is there is a way where I can change all the fields as string?? and a assign "N/A"
how can I assign a "N/A"to a boolean field??
also I have approx. 140 fields to evaluate, does the formula can be generic or I will need to create a formula for each variable??
Hummm... That doesn't make sense to me...
Try creating a new report against the Excel spreadsheet, and just drop all of the fields in the Detail format. Do you see all of the values?
Does the current report have any suppression logic?