Jump to content

This topic is 1584 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

 

Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

This topic is 1584 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.