So I've got a report that links via an account code. Basically the table for the account has a field called "rollup", which, may point to a different account code. In the event that two accounts point to the same rollup account, they need to be reported on together. I linked my database so that a second version of the table is linked based on the rollup field.
I then wrote this formula:
If isnull({table_1.name}) then
ProperCase({table.name})
else
ProperCase({table_1.Name})
with the basic idea being if there is a rollup code in there I want that account's name, but if there's not, I want the original table's name.
The problem is, when I set this formula up, it seems to exclude null values from the data and doesn't even pull the records. If I remvoe this formula and refresh, the records are pulled again.
Any idea what causes this?
IP Logged
