Apptio for All

 View Only

 Custom grouping

MANDEEP SETHI's profile image
MANDEEP SETHI posted Fri April 04, 2025 04:04 AM

Hi 

Am trying to group search results by using custom logic like following. I have verified the team name as correct but somehow it alwys goes to 'Others'. Am I using this operator correctly?

Any guidance would be hlepful

CASE
    WHEN
        [Responsible Team]=='AI- ADM Retail' or [Responsible Team]=='APP AI- ADM'
    THEN
        'ADMS'

    WHEN
        [Responsible Team]=='APP AI- SAP'
    THEN
        'SAP'

    Else 'Others'

Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Mon April 07, 2025 07:11 AM

Hello, @MANDEEP SETHI.

I do not recognize that scripting language in Cost Transparency or Planning. Is it in Targetprocess?

Two ideas that might help:

  1. Check the "==" clause. Might require a single one
  2. Break the WHEN case with the or clause in two separate cases, just in case.