Adding a forecast as a calcuted field

[Xclipse]

Hello @medpere

Thanks for your question. Please take a look at the blog below.

Using value day-7 to calculate new value

Hi all, im new to this community, so thanks for your help in advance! Im trying to figure out how to create a formula/calculated field for forecasting expected passengers on busses. As per screen i have the headcount per shift going forward on daily level (headcount_revised). From another source i get the past passengers per lane, shift and day (AGT_Ist). What i want to do is to use past utilization which is AGT_Ist / headcount_revised as per 1. and create another calculated field which shoul…