Ok, first I have to say thank you to everyone that has helped. I have taken way more then I have given in this community, and I really appreciate it.
Now onto the problem. I’m trying to create something similar to a sumifs function by using a Sum function with a select function, but I’m failing miserably. Here is the function that I have, but it’s not returning anything.
sum(
select(
employee ledger[employee pay],
and(
[_thisrow].[eid]=any(employee ledger[EID]),
or(
any(employee ledger[activity])=“AM Daily”,
any(employee ledger[activity])=“PM Daily”))))
LinkedIn
Twitter
