Posted 28 November 2018, 10:50 am EST
I have a single sum aggregate column that takes three (3) records with the number one (1) in each. This makes the sum aggregate for the group total to three (3).
I want to take the result of the sum aggregate of three (3) and multiply it by 40. Then I want to replace the three (3) aggregate with the new aggregate value of 120 (3 * 40).
How can I do this substitution?
