Formula difference value compared to average value

[MauricevDooren]

Good afternoon,

I can't get something done. I hope I can make use of your knowledge and expertise

In a table chart I want to display a value, the difference between the lead time and the average lead time. The lead time is a master item that does a calculation (closing date-start date). In addition, I need an average lead time. This is a dynamic field.

I myself had thought:
(closing date - start date) / GDPR (closing date - start date).

I then only get an error message:
Error in expression: Error in referenced measure

[Clement15]

hello, not knowing your data I am not sure of the formula but you can try this:

(closing date - start date) 

-

(

sum( total closing date - start date) 

/

count(total start date)

)

[MauricevDooren]

Thank you for your response. We are one step further. This formula works, but does not yet give the correct value.

The division should be done by the total average lead time. Now he's counting on the rule.

Is there anything I could do about this?

[Clement15]

And by replacing Total with All?