Percentage Calculations

Copper Contributor

I am trying to create a formula that will divide 100% between the values in column A, for example, if I first input figure a it will show as 100%, if I then input figure b it will work out percentage based on the higher value.  phots below for reference. 

TobyAnders_0-1711463265931.png

TobyAnders_1-1711463286897.png

 

 

1 Reply

@TobyAnders 

Try this:

=[@Values]/SUM([Values])