5 Replies Latest reply on Apr 18, 2018 5:45 AM by Zhouyi Zhang

    Variance Issue??

    Jill Rossi

      { FIXED IF [Fiscal Year]="FY19" THEN [Case Identifier] END: AVG([Total Value])}

      { FIXED IF [Fiscal Year]="FY18" THEN [Case Identifier] END: AVG([Total Value])}

       

      Calculating the variance using these two calculated fields is not yielding the correct calculation - any thoughts??