Forum Discussion

abhishekpati86's avatar
abhishekpati86
Icon for Helper III rankHelper III
9 years ago
Solved

How to Sum columns in edit queries.

Hi All,   I have a very simple requirement to sum the below 3 score columns using custom column, can anyone please help me with that.     I am using the above code and getting an error. Is...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi abhishekpati86,

     

    I agree with ankitpatira’s point of view, you can use the insert button to add column to instead of typing column names.
    For example:
     

     

     

    Notice: if your columns’ type not Numeric types, you should convert it to Numeric types before above steps.

     

     

    In addition, you can also use Number.FromText function to convert the string to Numeric.


    Regards,
    Xiaoxin Sheng