Do any of you know how to count the number of different currencies on a given supplier ? I want to create a condition that determines if the currency on a new incoming document is different from the least occurring currency on previous documents of the same supplier with the same company code.
Question
How can I count different currencies at a given supplier with the same Company Code ?
+1
You need to open a graph first.
As a dimension you will put the company code.
Imagine you take the company code info from table A col. B. As a dimension -> DISTINCT(A.B)
As a KPI --> COUNT (Currency Table. Column)
It should be crystal clear.
Login to the community
No account yet? Create an account
Login with SSO
Celonaut Login Celonis ID LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.