Another Best Practice recommendation is to have minimum number of calculated fields which contains the “Sum” or “Count” in them. These needs Re-firing at DB End and impacts the performance of the application.
Sharing the backend SQL for the same.
A.BUSCOMP_ID IN (SELECT B.ROW_ID FROM SIEBEL.S_BUSCOMP B) AND
B.ROW_ID = A.BUSCOMP_ID AND
A.CALCULATED = ‘Y’ AND
(A.CALCVAL LIKE ‘%Sum%’ OR A.CALCVAL LIKE ‘%Count%’);
OUTPUT TO E:\TEMP\Calculated_Field.TXT