Thank you very much for your response. Yes, I already have a calculated column in the list of items in the form. This column is of the type - calculated text value. The SQL works. However, I am unable to display this column on the report
hi, I would like to create a calculated column for a report with a list of items. This column, using SQL, should fetch data from another process. I want to map it based on the DET_Att23 ID for each row of the report:: select sum(DE.DET_Value2 - isnull(DE.DET_Value17, 0)) as nn from WFELEMENTS