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

    Fix LOD Calculation on a Filter Value

    Ritu Chandiramani



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




      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:




      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