5 Replies Latest reply on Oct 4, 2016 1:13 PM by Shinichiro Murakami

    Using Action Filters in Calculation

    Larry Tsai

      I am trying to use an action filter in my calculation to change my column headers based on the action filter value. My formula is:


      if [Action (Country,Region)]=TRUE AND [Country]="Canada" THEN (if [Document Type]="M" THEN "A" ELSE [Document Type] END) ELSE [Document Type] END


      This does not work for me. Instead, it is evaluating as true even when the action filter is not active. Any ideas how I can change my column header name based on my action filters?