I have repeated names that I am looking to sum via beast mode but the sum function is not working.
I am also looking to select certain department numbers from a department.
Thank you ^_^
Do you have a beast mode you're using? How is the sum function not working?
For your department numbers are you looking to get a part of the department name or are you wanting to conditionally add values together based on the specific department numbers?
You can use a case statement to conditionally sum your numbers together:
SUM(CASE WHEN `Department Number` IN (1,2,3,4) THEN `Value To Sum` END)
Hi @GrantSmith The sum is working now. For the department I am looking to select only certain department numbers adding those values together.
@GrantSmith you're the best!