This content has been marked as final. Show 10 replies
I have a data model where I have "Workers" who have records in a "PayDetail" table. This "PayDetail" table also has a linking to an "Order" table. HOWEVER, not every PayDetail has an associated Order (i.e you pay someone for undergoing HR training or recertification).
I'm representing this data in a Pivot table, and because of the structure, I end up with pay columns that have a "-" as their Order Number.
Is there a way I can say "if the OrderNumber is null then show Blah"? I've tried the following statement, but it didn't change anything:
IF(ISNULL([Order Number]),'OTHER',[Order Number])
Any help is greatly appreciated.