6 Replies Latest reply: Sep 18, 2017 6:20 AM by Rajesh Thakur RSS

    Ignore dual value in set analysis

    sandeep kumar

      I am trying to ignore a dual value in set analysis but it does not seem to be working

       

      Sum({<[Fact_Type] ={'O'}, Year = {'$(vCurrYearNum)'}, MonthNum = {'$(vCurrMonthNum)'},Month =,[WeekName]= >} Opening_Base)

       

      Month is the dual field here. The set analysis above gives the KPI for the current month. I have a line chart which shows Opening Base by month. If user selects a month, I don't want the KPI to change as this should always reflect the current months number. WeekName is working fine