Hi there, can anyone help me rewrite the formula below please… The IF seems to create ‘parameter is invalid’ error, but the ROUND is part is working as expected:
IF({Labour Cost Estimate} = 0, 100, ROUND({Days Act}/{Total Days Estimate}*100,0))
Have you used the AI formula builder yet?
Desiree - www.thecleverclovers.com
Hi there, thanks for the reply.
Yes I have…. It provided this formula originally but sadly it doesn’t work
What type of columns are the three referenced in the formula?
Desiree - www.thecleverclovers.com
{Labour Cost Estimate} is a formula: MULTIPLY({Total Days Estimate}, 650).
{Days Act}is a formula: {Hours Reported}/7.5 .
{Total Days Estimate} is a formula: SUM({Labour Est}).
(FYI, {Hours Reported and {Labour Est} are mirror columns)
Thanks again!
Hi @AlanC ,
just tried out your formula with some random values and a 4 column setup.
Everything seems to work. ( haven’t changed anything)
Do you still have the issue? Can you provide a little more input (what error and maybe a screenshot of the columns)
As you can’t divide by 0 with a meaningful result, you likely get an error for those items. As I don’t see all the numbers for the formula, I assume that there is also another 0 it the equation as only Labour Cost 0 should not throw an error.
My guess would be that there is a 0 also in the Total Days Estimate Column? 