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

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Hi Abhishek,

 

You can use the newly added functionality Invoke Function for this and It would be more creative solution as you can use them for other type of tasks as well.

 

To do so, 

 

1.Add a Blank query and Write the below code:

(Qscore as number, Rscore as number,Sscore as number) => Qscore + Rscore + Sscore

 

 

 

2. Go to your original query and Under the Add Column Tab, Select Invoke Custom Function.

and Choose the appropriate options and it will give you desire results. 

 

 

 

bajimmy1983's avatar
bajimmy1983
Icon for Advocate V rankAdvocate V
8 years ago

Very nice Solution and much more sofisticated! :smileyhappy: BhaveshPatel