Skip to Content
avatar image
Former Member

formula to check a measure for each month in report

I am required to make a webi formula that checks if a specific measure (from another formula) is = 0 , in the scope of each month. The problem is that the months itself is not a database column but another formula based on a date field in the database.

The report shows results per month and the table will then be conditionally formatted to hide a specific month if this formula is anything else than 0.

I have tried all kinds of variations like [measure] In([month]) to make this check for every month displayed. Can you give me any hints on how to make a formula that checks this measure for every month shown in the report?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 13, 2018 at 04:32 PM

    Create Dimension variable for measure values.

    V Measure=[Measure]

    Show/Hide=If([V Measure]>0) Then "Hide" Else [Month]

    Apply filter on Show/Hide variable where not equal to Hide to exclude months where values are greater than 0

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry Axel but still your requirement is not clear to me.I am bit confused.

      It will be good if you explain with example.If you can not share report screenshot then replicate in excel and explain with number of objects and expectation.