Unanswered

How to do simple sums with variable values?

(0) Share

Report

Posted on by Community Power Pla...

So I have a flow to analyse results from a quiz on MS FORMs.

I've got variables set up for the number of questions and the score. I want to email the person with their results and their percentage score.

I cannot figure out how to multiply or divide the values held within the variables so I have a percentage.

I may be going about this in completely the wrong way if so let me know.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

fchopo 8,003 Moderator on at

Like (0)

Report
Hello @Anonymous
Please, have a look at the following threads:
Sum multiple values: https://powerusers.microsoft.com/t5/Building-Flows/Calculate-sum-of-multiple-numbers/td-p/334399 by @RezaDorrani
Divide multiple values: https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-receive-decimal-number-result-after-dividing/td-p/195399 by @ScottShearer
You can also have a look at math functions reference guide: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
Hope it helps!
Ferran

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi!

you have initialized variables of type either integer or float, right?

All you need to use is to work with math WDL functions by means of expressions

math WDL functions documented here:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#math-functions

How to add expressions explained here:

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

Hope this helps

Was this reply helpful? Yes No
Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

You can use mul(), div() and other available functions to perform math operation. i would like to see what are doing to help you further.

i would suggest you to use compose action to perform there operations with your variable.

Like following expression multiple my variable with 10.

mul(10,variables('MyVar'))

Thanks

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (2)

Report
Hi @Anonymous,

You could initialize an integer variable named Score, then create multiple conditions to increase the Score by using the Increment variable action if the answer is correct, here I have 4 questions, so it has 4 conditions.

Then use the expression to divide the Score and Total score, then convert it into a percentage, my total score is 100, for example:

concat(string(mul(div(float(variables('Score')),float(100)),100)),'%')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No