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
Solved! Go to Solution.
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
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
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |
User | Count |
---|---|
49 | |
29 | |
23 | |
20 | |
20 |