Dear All,
I have an issue,
We have Material Type in Bex query which is an attribute of Material.
There are some # values showing for Material type. Which should not be display in the report.
I tried to write a code in 0Material Transformations. It is not working out.
Because, we have the query on 0pur_c01 cube.
Our ECC users are creating PO's with out material also.
For those PO's there is no material in the transaction data. In this case Material type is displaying # values.
I want to replace # with Others in Bex using If condition.
Please suggest me, How can write the formula at Bex Level.
Thanks,
Nag