topic Re: Formula difference value compared to average value in App Development

Formula difference value compared to average value

MauricevDooren — Thu, 14 Mar 2024 12:58:41 GMT

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

Re: Formula difference value compared to average value

Clement15 — Thu, 14 Mar 2024 13:19:38 GMT

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)

)

Re: Formula difference value compared to average value

MauricevDooren — Thu, 14 Mar 2024 14:12:54 GMT

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?

Re: Formula difference value compared to average value

Clement15 — Thu, 14 Mar 2024 14:15:03 GMT

And by replacing Total with All?