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