Hide Rows in Bex

[Former Member]

Hi Experts,

I am in middle of creation of a report.

I am stuck at one last step.

I want to Hide the rows where the the KF I used ( Amount in this case) is blank.

how to do this.

can anyone help

thanks

Arun

[former_member188975]

Hi Arun,

You can try that out with a condition that'll display Amounts > 0.

Hope this helps...

[Former Member]

I tried it out.

Its not hiding the Results with blank values.

[former_member188975]

Hi Arun,

You can try to force a zero in place of the blanks by creating a formula (AMT = AMT + 0), or try to change the condition >0.001

Hope this helps...

[Former Member]

I think that Bhanu's suggestion should work.

I have something similar, I created a formula key figure like this KF1 = KF1 + KF2 - KF2, maybe you should also use NODIM function.

good luck,

Sebastián.-

[Former Member]

Hi Bhanu.

as u have said, I created a CKF and the Amount now shows zero, then i created a Condition. But it was still displaying rows with "0" in the Amount Field.

I think whats happening is, the condition its applying on the Characteristic and allowing all the characteristic for which the condition is true, But since I am using selection in Rows, its showing unwanted rows too.

Can we put a condition on KF, saying that If this KF is 0, dont display the entire row.

I know i am not giving nuf information abt the unwanted rows, but its complicated. need to send screen shots for it.

Hi Sebastián, thanks fr the NODIM advice.

[nikhil_chowdhary2]

Hi Arun,

What conditioon have you set? I have created a condition saying:

<i>Evaluate the condition displayed below for:

All characteristics in Drilldown independent

Display all values where atleast one of the following applies:

Price <> 0</i>

And its is working perfectly for me. Try the settings as mentioned above and see if it helps.

Regards,

Nikhil

[Former Member]

Hi All,

Thanks much fr help!

the problem is solved now.

problem wasnt with the condition. It was with the structure and there is a option called " Also use zero supression for elements" in the property of structure.

points assigned to all.

thanks

Arun

[nikhil_chowdhary2]

Hi Arun,

Please mark this thread as "problem solved" by self so that people know through the dark green star which is displayed.

Regards,

Nikhil