periodOverPeriodLastValue offset not static

Hi rbrady, Are you filtering your data based on the StartDate and EndDate parameters? If so, be aware that these filters might also filter out the data that your periodOverPeriod function requires for the comparison and, hence, shows a blank cell. This article explains a way how you can prevent this from happening, while still filtering each column as desired, using ifelse logic within calculated fields.

Did this answer your question? If so, please help the community out by marking this answer as "Solution! If you found a different root cause or solution in the meanwhile, we would be happy if you could share it with the community as well.