Increment variable math formula

[Lizzlenizzle]

Hi all,

I have a flow I’m trying to make where I take an increment valuable and create a percentage. 
I have a flow for an evaluation SharePoint List where I’m trying to update some fields on a different SharePoint list that summarise the fields on the other list. 

I have successfully created a variable for the count, an average of a column, but now I’m trying to create a percentage of an occurrence of some values in a column. 

This column has 4 different possible values (Not at all Confident, Unsure, Confident, Very Confident). I want to find all the Confident and Very Confident for my percentage. I have successfully set up the condition and the output shows it is counting correctly. But then I am trying to then turn it into a calculation and falling short as the input and output is 0. Does anyone have any idea of how to help? 
See my flow below, I’ve circled in red the parts that I can’t get to work. 

 

 

 

 div(variables('Confidence'),outputs('ItemTotal'))

but also tried

mul(div(variables(‘Confidence’),outputs(‘ItemTotal’)),100)

 

 then the outputs:

working for increment

 not working for compose 

 

[Expiscornovus · Accepted solution]

Hi @Lizzlenizzle,

Can you try and converting the integers to floats. For example try this expression in your compose action (with the name Division).

mul(div(float(variables('Confidence')),float(outputs('ItemTotal'))),100)

[Lizzlenizzle]

@Expiscornovus 

Amazing! It worked, thank you so much! Still getting used to using expressions so this was super helpful!!