Beast Mode (Card)

Fadem

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 ^_^

GrantSmith

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

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)

GrantSmith

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?

Fadem

Hi @GrantSmith The sum is working now. For the department I am looking to select only certain department numbers adding those values together.

Thank you!

GrantSmith

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)

Fadem

@GrantSmith you're the best!