How to filter a formula

[Former Member]

Hallo,

I have a query with 5 columns. 1 column is based on a formula that can hold 1 or 0.
Now I only want to show the data if 'this' column is 1. Does anyone know how to do that?

it's basically like putting a restriction on the column saying only take 1. But since it's a formula it doesn't work. Also tried adding a condition saying

'this column' == 1, but these returned nothing.

[former_member202718]

Hi Bart,

Also you can put a condition with Greater than 0 and this should display 1.

rgds

SVU

[Former Member]

Hi SVU,

the weird thing is, I already tried creating a condition with '== 1' and '> 0', but when I execute the query it's says no showable data?

Could there be something I'm overlooking?

[Former Member]

I think I know why it's not working, I have multple characteristics like Charter, profit center, employee but when I use the condition only on employee level it works. So why doesn't it work when I have multiple navigation characteristics?

[Private_Member_49123]

Hi Bart,

As suggested by Ricardo, Conditions could be used here.

Create a new condition and use your KF and make it as "= 1".

This suffices your requirement.

Thanks,

Shreya J

[Former Member]

You can use the Conditions tab.

In there créate a new condition and add the restriction:

Key figure = "1/0 key figure"

Operator = Equal

Value = 1

With this you can "avoid" the zeros rows.

Regards!

RG

[KodandaPani_KV]

Hi,

you can change the formula can hold 1 not 0 - then you will get the desired report.

for key figures not possible to resctirct with the vlaues it is possible to restrict only char.

Thanks,

Phani.

[Former Member]

Hi Phani,

what do you mean 'change the formula can hold 1 not 0' ?