6 Replies Latest reply on Nov 6, 2018 6:47 AM by Deepak Rai

# Fix LOD Calculation on a Filter Value

Hello,

I have an LOD calculation in my workbook  which calculates Membership (See below formula)

{ FIXED  [RGN_CD], [YEAR], [MONTH], [MJR_AREA_NM], [AGE_BAND_CTGRY_DS_TX], [LINE_OF_BUSINESS], [LINE_OF_BUSINESS_SGRP], [UTLZTN_TYP_CD] : MIN([MEMBSHP_CY_MTH_CT])}

Now UTLZTN_TYP_CD is a filter which has three values KFH, Claims and Referrals.

Currently this calculation changes based on value that I select in UTLZTN_TYP_CD filter.  I need to make the calculation fixed on value  UTLZTN_TYP_CD = "KFH". I tried modifying the formula as below:

{ FIXED  [RGN_CD], [YEAR], [MONTH], [MJR_AREA_NM], [AGE_BAND_CTGRY_DS_TX], [LINE_OF_BUSINESS], [LINE_OF_BUSINESS_SGRP], [UTLZTN_TYP_CD]  = "KFH" : MIN([MEMBSHP_CY_MTH_CT])}

But this doesn't work.

Any insights to achieve this functionality will be very helpful.

Ken Flerlage, I have attached the packaged workbook for your reference

• ###### 1. Re: Fix LOD Calculation on a Filter Value

Any chance you could provide a packaged workbook so we can get a better look at the problem?

• ###### 2. Re: Fix LOD Calculation on a Filter Value

You need to write condition after MIN

{fixed. D1, d2, ....    MIN( if this = abcd then whatever end)}

• ###### 3. Re: Fix LOD Calculation on a Filter Value

Hello Ken,

Did you get a chance to look at the packaged workbook yet and help me figure out a solution for what I am trying to achieve?

Best Regards,

Ritu Chandiramani

• ###### 4. Re: Fix LOD Calculation on a Filter Value

I think it works now. You need to add all filters to context and Change the calculation like this, so when you change the Filter you are getting only one value for claims and referrals and 2 values for KFH.

Thnaks

Deepak

• ###### 5. Re: Fix LOD Calculation on a Filter Value

Hello Deepak,

Thanks for providing the solution. Is there  a way not to add filters to

context. I have other LOD calculations which will get impacted because of

this.

Best Regards,

Ritu Chandiramani

• ###### 6. Re: Fix LOD Calculation on a Filter Value

Use INCLUDE wherever FIXED is used and take out filters from CONTEXT