SharePoint List-Require a calculated column to multiple off 2 columns then divide by 7.5 to work out FTE Impacts

Question

Hi Team

I'm having issues with creating a calculated column to multiply off two fields and then to divide by 7.5 to work out the FTE Impact.

The formula I've entered in is [How many bankers are scheduled for training (RA1)]*[Total Duration of Training in hours (RA1)]/7.5]

For some reason I get the below error- Can someone please help me with the correct formula I should be using?

Regards

Harry

Answer 1

Hi @Harry N Nomikos

The reason for this error is that you entered one more symbol "]" at the last of your formula.

Just change your formula

[How many bankers are scheduled for training (RA1)]*[Total Duration of Training in hours (RA1)]/7.5]

into

[How many bankers are scheduled for training (RA1)]*[Total Duration of Training in hours (RA1)]/7.5

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.