PeriodRolling(measure,-64,-52) -64 is less than -52.

Hello Steelbird, Re: How can we calculate Rolling 13 Week LY sales ? Period Rolling should be able to handle this. PeriodRolling(measure,x,y) 1) Measure is any measure you want to aggregate 2) X is the period to start * a rolling 13 weeks would be the previous 12 weeks plus the current month, * the starting period would…

Formula writing is very logical. I read your formula to say, "When the Salary Basis Name is equal to the Salary Amount, then..." But the Salary Basis name is text, 'USHOURLY', right? And the Salary Amount would be the hourly rate of pay, or a number, correct? I don't see where text could equal a number. Try reading up on…