Skip to Content
avatar image
Former Member

How to filter a formula

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Jan 06, 2015 at 02:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2015 at 12:26 AM

    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


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2015 at 05:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 06:12 AM

    Hi Bart,

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

    rgds

    SVU

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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?