As I put some data together and I want to get a variance percent from different cycles. I have put together a flow with row minus row-1/row-1 on a multi formula. However the calculation I am getting back isn't correct? What could be causing? The row above Highlighted row the 5 is correct but the Highlighted row the 10 should be .10% not 10.
Solved! Go to Solution.
@McD_Ford are you able to provide any more detail/the exact expression/a larger screenshot/your workflow? I can't replicate the issue from the brief info you've given here and the issue is likely coming from something we need a bit more context for.
How does this look @McD_Ford? Obviously only just rebuilt a little section so can just take the expression/tools as you need. I've left the raw value as is but you can obviously multiply this by 100 to show as a percentage/round as you see fit. Basically just changed the output to be numeric instead of string and removed the quotes from the else condition.
@DataNath I appreciate your time and advance. after a couple tweaks it worked awesome. Thanks so much.