I have a report where the same companies are showing multiple times as they have multiple status next to them.
e.g XYZ Ltd - Status Initiation
XYZ Ltd - Status Launched
XYZ Ltd - Status Post Launch
I only want the record XYZ Ltd - Status Post Launch to show on the report.
I can...
I have sorted it - Madawc's formula worked, I was applyinhg the formula via the selection editor which is why it was not working for me.
When i add a formula field to the report the formula works fine.
All sorted thanks.
I have a report that is returning True and False values from a tick box field within the database. I only want the report to display the true values. The problem is that I have 12 tick boxes in a row and I can't get the formula correct in selection editor without skewing the report results.
I am trying to supress a row of data but only when a blank value is returned in a report field.
Is there a formula for this or somr conditional formating?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.