I have the following calculation which runs every night at midnight to calculate the utilisation of an asset:
When this calculates at midnight, the value is always close to 1, indicating that the asset is always available, when the actual utilisation is usually between 80-90%. When I evaluate this calculation the next day or backfill the calculation again, the value will change to the correct value, indicating that the calculation is working as it should.
I don't really want to backfill the calculation everyday to get the correct value to come through. Does anyone know what the issue could be or if I need to modify the calculation?