It would be useful to be able to sync the transposed value to the reports rather than the original.
For example, I have a Gradebook with 4 columns:
Term 1 Grade
Term 2 Grade
Term 2 Grade
Overall Grade
The Overall Grade is a calculated column that is the average of the three term grades. The term grades are A*-U. On the calculated column I can right click and view the transpose grade but there is no way to map this to the reports. So parents are going to see the number behind the grade rather than the grade itself.
E.g.
Term 1 - A* (9)
Term 2 - A (8)
Term 3 - B (7)
The Overall Grade is an A, but what is syncing to the reports is "8".
