Percentages not matching accuracy of data

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.

Workflow

Tips and Tricks

Preparation

Accepted answers

DataNath

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.

Gross variance calculation.yxmd

All comments

DataNath

@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.

McD_Ford

@DataNath Thanks for responding. Please see below on what strain of the larger flow I am working on. If I use a smaller sample it works fine. But for some reason with my current data it will not populate correctly.

Test WorkFlow.yxwz

DataNath

Gross variance calculation.yxmd

McD_Ford

@DataNath I appreciate your time and advance. after a couple tweaks it worked awesome. Thanks so much.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703