Set Up Equations For Rugby Union With Bonus Points

Hi @webfeetdesign,

You can try the following:

Total Points = Win x 4 + Draw x 2 + (Tries >= 4) + ((pointsagains – pointsfor) <= 7)

Thanks,
Savvas

Thanks for that @savvasha is this correct then? IMAGE

You can try some scenarios to check if it is working as it should.
If I was you I was going to add two more brackets ((pointsagains – pointsfor) <= 7) instead of (pointsagains – pointsfor <= 7)

Also you should use those signs (https://snag.gy/UrfjtB.jpg) and not those signs (https://snag.gy/gEtpds.jpg)

• This reply was modified 6 years, 5 months ago by Savvas.

Where would you put that equation? Which column – IMAGE

Thanks]

Alex

That didn’t work I’m afraid. I think I’ve got the points system sorted for scoring totals but I can’t seem to get the bonus points worked out.

Alex

Can you share your equations again please?

The problem is that it doesn’t calculate the bonus points. I can manually add a 1 in the bonus points field in the results section. Here is the results data that I’ve added for a sample.

This is the equation configuration for the Table

Thanks

What is the equation for the bpfor?

This is the league table when the results have been added. You can see that I have added the 1 in the bonus point section but it. I would like it to be automatically calculated if possible by taking the tries (+4) or the losing less than 7. Sorry if that makes no sense.

Alex

What is the equation for the bpfor?

That adds the 1 that I added manually in the results table.

Strange… Can you try the following equation exactly?
https://snag.gy/jAGTXJ.jpg

I did that. Did you mean to put in the divide sign?

It didn’t work. The league table now shows 29 points. It should be 4 for the win plus 1 for the bonus point, totalling 5.

This is what I have after adding your equation: IMAGE

The divide sign was by mistake ??

Please try the following code
https://snag.gy/Ul9aP2.jpg

I changed it but that sent the league into maddnes ??

See here