How to calculate a value base on a value in MS Forms

[Jorgen]

hey,

Don't know if this is a stupid question or not but i want to do an operation based on a value that i get from a MS Form.

i.e User enter a foreigen currency value (always in Swedish Krona)  and i want to divide that with the Exchange rate to get USD - sound quite simple right but i cannot figure out how to do it nor do i find anyhing googeling it!

or number wise 9,500 SEK (from "list of response") / 9.5 (can be hard coded) = 1,000 USD.

quite new to Flow so any hits appriciated ,

Jörgen

anyone got any good advices?

regards,

Jörgen

[ScottShearer · Accepted solution]

@Jorgen:

Here is an example that I believe will work for you.

First, you need to convert the currency data returned from Forms to a number (Float).  I convert the string returned from Forms to a Float using he Float expression.  Then, you can make the calculation using the div() expression.

You may want to add error handling for the case where a user submits something other than a number in the Form.

If this addresses your issue, please mark your question as Solved.

If not, please explain.

Scott