Beast Mode (Card)

Hi guys!

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.

Please help!


Thank you ^_^

Best Answers

  • GrantSmith
    GrantSmith Indiana πŸ₯·
    Accepted Answer

    Hi @Fadem

    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?

  • GrantSmith
    GrantSmith Indiana πŸ₯·
    Accepted Answer

    Hi @Fadem

    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)
    

Answers