Convert a zero to null or empty

Hi,

I am working on a cube and I want to hide the results of a calculation if it is zero.

It is an inventory problem based on a transaction pattern. (add plus one to the inventory, add minus one to the inventory).

The sum of those two is zero, but the cube get messed but by thousands of zero.

I found some solutions of displaying 0 for NULL but I want to dispaly NULL (or empty) for 0.

Any ideas ?

Constantijn

September 10th, 2015 8:50am

Hi 

you can hide values buy using an IIF statement, it would look something like this

WITH MEMBER MEASURES.IIFDEMO AS
	IIF([Measures].[MyMeasure]=0, NULL,[Measures].[MyMeasure] )

Free Windows Admin Tool Kit Click here and download it now
September 10th, 2015 9:06am

Thanks !
September 12th, 2015 4:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics