TIBCO Spotfire

I'm trying to find a way to make a custom calculation evaluate No Values (displayed as ---) as 0 when you're doing a custom calculation.  I've seen similar threads on this suggesting entering in a 0 value for all possible data values but the datasets we are using are farily large and to do that effectively would create trillions of addtional records and thus causes poor performance.  I'm open to using an S+ script to over ride this if anyone knows of an effective way this can be accomplished using S+ code.

Can't you use a new pivot table (not a CrossTable visual) to check for NULL values in the pivot table?

Christof

After a few tweaks using the pivot table did accomplish what I needed.  Thanks!

Thanks for the feedback!

Can you quickly elaborate on what you achieved with the pivoting?

Thanks,

Christof

 maybe you can google and use the yahoo answers