Using Excel Forumla in Assign Activity

Hello Everyone!

I need to output web scrapped data to an excel file, however, before doing that need to get some calculation done on the scrapped data.

To do the calculation I am using 2 Variables defined as INT32 type earlier in the workflow. When I use the function of rate(10,0,PNLFSTYR,PNLCRY). Where PNLFSTYR, and PNLCRY are INT32 variable containing data scrapped from the web.

The Compliation Error I get is below:

Pass it as a string @Dhiraj_Kanal

Tried doing that as well, get the same error with message String to Double is disallowed

There is a Variable type “System.Double” using it fixed the issue. Thank you for looking at the thread.