Percentages

[Neil Scrivener]

Hi Guys, 

Sorry of this in the wrong forum! Complete newbie here! 

I have two questions:

1. If I have a Table with two Fields - say 2019 Results and 2018 Results - what would be the best way to show a percentage difference? Is it to have a third Field, or is there a better way? 

2.  Is it correct to use the "Calculation" field to find the %? Could someone please show my the syntax, as it's not working for me!

Thanks!

N

 

[comment]

3 hours ago, Neil Scrivener said:

I have a Table with two Fields - say 2019 Results and 2018 Results

I hope you don't have fields whose names begin with a digit.

 

3 hours ago, Neil Scrivener said:

what would be the best way to show a percentage difference?

You could use a calculation field (result is Number) =

Result_2019 / Result_2018 - 1 

and format it to display as Percent.

 

But:
After 2019 comes 2020 - and presumably you will want to add a field for that, and for the year after that, and so on. This is not a good arrangement to have: there should be no need to modify the file's schema just to add more data. You didn't tell us what these results represent, but normally you would have a record for each result, with one field for the value and another field for the year.

 

[Neil Scrivener]

Thanks all working