Skip to Content
0
Former Member
Jan 05, 2012 at 08:36 PM

Replacing blank characteristics in planning cube with Zero

32 Views

Hi,

We have a requirement in which we want to replace the blank values of 2 characteristics with 0 without changing the key figure values.

Let me give an example.

Suppose A,B,C and D are characteristics in planning cube and K1 and K2 are two key figures.

A record in planning cube will look like :

A/B/C/D/K1/K2

In some records, characteristics C and D might be blank

or

Only characteristic C is blank

OR

Only characteristic D is blank

Our requirement is to replace the blanks in characteristics C and D all the above 3 cases with 0 without changing A,B,K1 and K2.

Pls let me know if we can use any standard planning function to achieve this or I have to write a FOX formula?

And if FOX formula is required then, pls share the syntax.

Regards,

Ankur