7 Replies Latest reply: Mar 5, 2012 2:42 PM by Debbie Pyykkonen RSS

    Max() not working in set analysis

      I am trying to get this formula to work to calculate the prior year's data.
      I have a chart that I always want to show the maximum year selected in one column and the prior year in the other column based on the maximum year selected minus 1.
      For some reason this keeps ignoring the this portion [Fiscal Year] = {"=$(=max([Fiscal Year])-1)"}  What am I doing wrong?
      =Count({<[Fiscal Year] = {"=$(=max([Fiscal Year])-1)"},[Fiscal Year and Month]=,[Fiscal Year and Quarter]= >} distinct [Order Number])