Limit on Expression

[#1]

I have table with dimensions DATE and Company. Expressions are: TOTAL LOSS and CHANGE.

At the moment all the data is being displayed but I only need to display rows where CHANGE is not < 50%. This way I should only have rows where data's missing or CHANGE is over 50% left.

Any ideas how to do it?

[Anonymous]

You can restrict the dimenion with the definition of CHANGE expression < 50%.

E.g. Create a calculated dimenion with the name Company and IF(CHANGE_formula <50%, Company, '').

So only values of the Company dimension that satisfies CHANGE <50% will be displayed!

Regards

MultiView

[#3]

I tried this and get Error in calculated dimension message.

Also, I need values that are NOT < 50% otherwise missing values would be excluded. My goal is to display all the missing values and the ones that are over 50%

[Anonymous]

Could you upload the app with sample data?

Regards

MultiView

[#5]

uploaded a sample app with some sample data in the main question thanks

I tried using aggr() with an if statement and sum() but still nothing

[#6 · Accepted solution]

Updated the file, I only need to display value where NullCheck = 1.

Would it be possible to use calculated dimension to solve this?

if (

aggr(sum(LOSS)-above(sum(LOSS))/above(sum(LOSS)) <= -0.5,MEMBER_NAME) , MEMBER_NAME,0)

This doesn't display the needed results, should I be using AGGR()?

Just added checks for all the dimensions and seemed to work this time.