Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

sum column error

hi ,I need to sum all the values of one coloumn, but unfortunately it showing some syntax error? can someone have a look and let me know, how to fix this?     Regards, vinod  
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

vjnvinod

 

You have an extra ")" where it should be a "]". Try this:

 

TERFYTDUSD = SUM(Outbound[TER_FYTD_USD])

 Hope this helps,

Parker

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

Anonymous

 

thanks but

still not able to figure out, see the below error

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    vjnvinod

     

    It looks like you're trying to do this sum in a Calculate Table expression. Try creating a measure or calculated column and then try this formula.

     

    Parker

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      8 years ago

      Anonymous

       

      thanks,

      I actually wanted to create a new table, by summing up of one of my coloumn in a different table.

      how do i do that?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        vjnvinod

         

        There may be a more elegant way of doing this but this works:

         

        Table =
SELECTCOLUMNS(
   FILTER(
      Outbound,
      Outbound[TER_FYTD_USD]
   ),
   "New Column",
   SUM(Outbound[TER_FYTD_USD])
)

        Hope this helps,

        Parker

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Maybe create a Measure with a formula like TERFYTDUSD = CALCULATE(SUM(Outbound[TER_FYTD_USD]))