Dear all,
I created a flow in which I get input (hours in a contract) from a Forms, which then calculates a price and responding taxes.
These informations are all collected correctly, but when I try to transfer them to my Word file via quick parts, it always messes up the format of that number.
Here a quick explanation:
- input via Forms (hours) is 10, which will be multiplied by 100 to get the final net price of 1000€
- then the taxes are calculated with a formula, lets take 19% which equals in 190€, so 1190€ in total
- that number is used in "update file properties" and published to sharepoint column name "total"
- when I add the quick part "total" to my word file, the result will show up as 1190
but what I am aiming for is, to have it formatted to 1.190,00€. that does work in some manner, but if the number contains a decimal, it messes up my document.
do you have any idea on how to use the output of my formula as a currency or at least a decimal number with 2 digits, formatted to my wanted format?
I tried a lot of different ways with formatNumbers(), i read all of the knowledgebase articles, but i wasnt smart enough to figure it out on my own.
Any kind of input is highly appreciated.
Cheers.
