2 Replies Latest reply: Sep 14, 2016 10:08 AM by Mark Pratt RSS

    Filtering with calculated fields

    Mark Pratt

      I have numerous calculated measures for instance "If(Account_Type_Description = ('Demand Deposit'),(Count(distinct{<DDA_External_Tran_Code={'5'}>}DDA_Description_Link)), (Count(distinct{<SAV_External_Tran_Code={'125'}>}SAV_Description_Link)))". The problem is if I filter on DDA_External_Tran_Code say value "9" I'm still getting the count for value "5" in the measure. I have similar issues throughout the app. How do I fix it? If I select "9" I want this calculation to be "0". Please help.