Aggregation function with a if -statement

[Applicable88]

Hello,

i have following function:

=Aggr(If(Not IsNull([Employeenumber]),Ordernumber),Ordernumber)

I don't get the real meaning of this function, since "ordernumber" is there two times. 

What will it return here?

Thanks in advance.

Best.

[marcus_sommer · Accepted solution]

It creates a calculated dimension for the field Ordernumber - whereby it checked for each Ordernumber if there is an Employeenumber - if not those values won't be included. Fot the logic take a look on aggr() in the help or search for it here in the community.

- Marcus