How works multiple COUNT_TABLE in number component formula editor with table joined?

I have two tables "Ta" and "Tb" in join directly, Tb is the master case table and the relation is "Tb" 1 -> N "Ta" . In formula Editor inside the number component COUNT_TABLE("Ta") = 1305 and COUNT_TABLE("Tb") = 7144 and all is correct. When I create a new number component with COUNT_TABLE("Ta") / COUNT_TABLE("Tb") I retrieve the number 1.2219..... I don't Know Why! I expect 1305/7144 = 0.1826. Components are without filters. How can I use multiple COUNT_TABLE in the same formula?

Thanks,

Alex Giorgini

Page 1 / 1

Hi @alex.giorg ,

I think this is caused by the relation you mentioned: "Tb" 1 -> N "Ta". In other words, multiple items in table "Ta" are bound to one item in "Tb". What Celonis does in you COUNT_TABLE("Tb") formula, is only counting the rows that are bound to "Ta".

Since the join consists of more rows in "Ta" then "Tb", you get a result higher than 1.

My suggestion is to change you formula to COUNT_TABLE("Ta") / GLOBAL (COUNT_TABLE("Tb"))

For more information about the GLOBAL() function, please go to the docs.

Kind regards,

Jan-peter

yes, I agree with @janpeter.van.d

Thanks,

now all is clear, I solve my request using the PU_COUNT function.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN