Skip to Content
0
Former Member
Apr 29, 2014 at 07:38 AM

IF Condition in BEx

28 Views

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