Performing calculations with values from Google Sheets

**ysoon** · December 9, 2016, 2:27pm

Having trouble trying to get the result in “Total” (multiplying one value with another in the same sheet).

Is there a way to do this?

**kellseyshaw** · December 9, 2016, 3:42pm

Hi Yun,

You’d need to the user the Number service to perform calculations

**ysoon** · December 9, 2016, 11:49pm

Hi Kellsey,

Thank you for your prompt reply.

However, I’m still not getting the result.

Is there something wrong with my code?

 Total: $ math.eval('{{ask_quantity.parsed_answer}} * {{connect_to_stocks.results_+_gsx:price    {{ask_items.parsed_answer}}');

**kellseyshaw** · December 12, 2016, 11:00am

Hi Yun,

You would need to use the calculation in the Numbers service and then use the output of that service in your message

**ysoon** · December 13, 2016, 8:49am

Hi Kellsey,

Well noted on your reply.

However, the “Number” action failed to execute as according to the logs: “The request failed because something unexpected had happened.”.

**kellseyshaw** · December 13, 2016, 9:06am

Hi Yun,

I believe that it may be the docs that need to be updated. If you remove math.eval and the single quotes, the calculation will work

**ysoon** · December 14, 2016, 3:21am

Hi Kellsey,

It works! Thank you very much.

But the this Calculate action is not executing when I replaced the variables with a Collection Output.

**kellseyshaw** · December 14, 2016, 2:01pm

HI Yun,

I’ve tested this and it seems to be working fine for me.

Are you seeing an error in your logs?