Ticket #31131
One of our summary calculations is selecting an account type that equals 74. This is a CHAR(3) *RIGHTJUST field. We recently went to change the account type in the calculation condition from '74L' to '74' and then when the summary was ran, the column was blank.
Informed customer that conditional calculations do not take *RIGHTJUST into account. However an easy way around this is to create a calculation to TRIM() the leading spaces of the *RIGHTJUST field prior to using them in a condition expression of another calculation.
Asked on February 15, 2021