ViewZeroOut Function

vins · Post by **vins** » Sat Aug 17, 2013 6:31 pm

Hi All,

I have a static picklist defined for a measure element say customer and if i use ViewZeroOut function. Will it work successfully because probably, Customer element will not allow to insert 0 value.

Waiting for your inputs!!

Thanks & Regards
Vins

Wim Gielis · Post by **Wim Gielis** » Sat Aug 17, 2013 9:48 pm

vins wrote:Will it work successfully because probably, Customer element will not allow to insert 0 value.

Is Customer a numeric element in the measures dimension? If not, it will be '' in a text cell instead of 0 in a numeric cell.

Anyway, the ViewZeroOut function will clear the cells in both cases.

declanr · Post by **declanr** » Sat Aug 17, 2013 9:59 pm

Wim's answer is entirely correct so no more information is needed there.

I would however pose the question of why you didn't just test it out? It would be a 1 minute job to create a dummy cube and process and then check the results.

TM1 Forum

ViewZeroOut Function

ViewZeroOut Function

Re: ViewZeroOut Function

Re: ViewZeroOut Function