multiplying in a word template

[nmccool]

trying for weeks to multiple the quanity and cost cloumns, then subtotaling, adding tax and totaling it all in a word template.  Started with and without (int) and (float); getting errors, see formula and errors.   

[abm · Accepted solution]

Hi  @nmccool 

Try to do the int coversions inside two compose flow steps for both response details. Finally pass these two compose outputs in your multiply expression.

[v-litu-msft]

Hi @nmccool,

Could you please share an example output of the response?

Do these values of quanity and cost column have dots?

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.

[nmccool]

so i took your advise, and created an int for both items needing to be multiplied and then the compose to multiply and it doesnt like it...I am obviously doing something wrong .... just know I am new to Flow

[nmccool]

then i changed to a float, and it worked on the fo=irst cost, so i went all the way down, and i got the errors

[nmccool]

the cost will, as it will be dollars and cents, but it will not have a dollar sign, see some examples of the cost and qty

[v-litu-msft]

Hi @nmccool,

If it has a dot, you can use the split() function to process the value, for example:

The 13.46 is the value I get from the excel table. If I want to get the integer part 13, I need to convert it into String first, then use the split to get the array [13,46], then get the first member split()[0] to get 13, then convert the String "13" into an integer.

int(split(string(outputs('Compose_2')),'.')[0])

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.

[nmccool]

i dont see how this will work.  The numbers i have to convert arent known until someone updates Microsoft Form i have linked to SharePoint; thats where the info is coming from.  Looks like you are converting info already known.  

[v-litu-msft]

Hi @nmccool,

Yes, the value in my example processed is known, but this is just a method, you can use the method to process the field get from Excel.

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.