Share
Report
6Hi all,
I have an excel table with a column called ‘date’ and another called ‘sales percentage’, there are other columns as well.
My flow is as follows:
Compose: first(split(datedifference(‘1899-12-30’,startofday(adddays(utcnow(),-1))),’.’))
i then have a ‘Get a row’ action which returns only the row where the date equals the compose output, which should be yesterdays date. (This all works fine)
i am then posting to a chat
sales percentage = and the sales percentage link.
this all works except that the return value of sales percentage is shown as 0.899 but in the excel table It says 57.2% (the column is formatted as a percentage)
i hope someone can help and I thank you for your time 👍
Categories:
I have the same question (0)
All responses (
Answers (
