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 Coach
    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?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • GrantSmith
    GrantSmith Coach
    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)
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    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?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • 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
    GrantSmith Coach
    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)
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • @GrantSmith you're the best!