Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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