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?

Regards,

Axel

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hello, i can only illustrate what i´m looking for with something like this.

    The measure shows 0 for month: Jan + Feb so these months will show.

    The measure shows 43 for March, marked red, and thus will be hidden/ not printed in the table.

    //Axelillustrate.jpg

    illustrate.jpg (57.6 kB)
  • Can you please share the screenshot of data and expected result.

  • Get RSS Feed

1 Answer

  • Feb 13 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.