Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the best way to show transactions where the sales rep is not filled in (Null)? The list box shows null values as '-', but I cannot select it.
Thanks,
Dinesh
You need to trap those null values as exceptions in your load script, try
if(isnull(salesrep),'Unknown Rep',salesrep) as [Sales Rep],
You need to trap those null values as exceptions in your load script, try
if(isnull(salesrep),'Unknown Rep',salesrep) as [Sales Rep],
In the load script, you can map them to a blank.
if(isnull(RepName), '', RepName) as RepName
That should solve your issue I suppose.
Let me know if it works.
You can also use Set Analysis, like this:
=Sum({$<TransactionID = {"=IsNull(SalesRep)"}>} Sales)
Regards,
Mike.