Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calcualte(sum giving an error

Hello Community, i am trying to create a calculated column and i am getting below error.Can i get suggestion? Thanks   Error Message"The expression contains multiple columns, but only a single col...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous

    Perhaps like this?

     

    delete after use =
CALCULATE (
    SUM ( [RAW Valid Months] ),
    FILTER (
        ALL ( '03- Contracts'[Sales Org] ),
        '03- Contracts'[Sales Org] = "AMERICAS"
    ),
    FILTER (
        '04-Software ',
        '04-Software '[P Identifier] = '04-Software '[RAW Unique]
    )
)

     

jthomson's avatar
jthomson
Solution Sage
7 years ago

Try using a comma/semicolon depending on your localisation instead of &, if it's still coming up you may need to make some sort of custom column to compare the two 04-Software columns to see if they're equal and then use that in your column

Anonymous's avatar
Anonymous
Not applicable
7 years ago

thank you so much for your suggestion.I have tried with , but i am getting the same error.

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

    Perhaps like this?

     

    delete after use =
CALCULATE (
    SUM ( [RAW Valid Months] ),
    FILTER (
        ALL ( '03- Contracts'[Sales Org] ),
        '03- Contracts'[Sales Org] = "AMERICAS"
    ),
    FILTER (
        '04-Software ',
        '04-Software '[P Identifier] = '04-Software '[RAW Unique]
    )
)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you so much AIB.

      • AlB's avatar
        AlB
        Community Champion
        7 years ago

        Anonymous

        No worries.

        If you're interested, in this article you can read why your first approach was not working.