I use Monday.com to track our cashflow with projects and as we partner with subcontractors, this means that we earn a percentage on specific items. I had created a formula column to calculate profit by using the formula: Rate (Excl. VAT) x Profit % e.g.
£2,000.00 x 50% = £1,000.00
Just now, it has stopped recognising the percentage in the Profit % column and recognises it as a number e.g.
£2,000.00 x 50 = £100,00.00
Has anyone else experienced this? I hadn’t changed any formulas, it’s just randomly happened which has completely screwed up our cash flow projections for the last 5 years.
I can move the decimal in the percentage by two to project the right amount but it causes confusion with subcontractors when 50% is now represented at 0.50%.