Skip to main content
Question

Summing up a numeric field from different entries.

  • March 13, 2019
  • 0 replies
  • 75 views
Hi, I would like to ask how to solve the example below:

Under the Salary table, I have three records: Record 1, Record 2 and Record 3.

Record 1:
  Month: 201902
  Money: 80

Record 2:
  Month: 201911 
  Money: 90

Record 3:
  Month: 201905
  Money: 70
 
 Is there a way to combine the Money field of the 3 records in another field (i.e Year 2019)? So for this example, the Year 2019 field should get the sum of 240.

 Thank you for the help!
This topic has been closed for replies.

no problem,
Just make a new table called Years and load it with a bunch of years.
2019
2020
2021  etc

then make a formula numeric field on your Records table

ToNumber(Left([Month],4))

Then use that field in a relationship to Years and sum up your records.


Terms & ConditionsAccessibility statement