I have a file which has daily balances. I need to find the Average of the daily balance as the last record. I have selected the report summary functions from WRKQRY and have given (2=Average) on the desired field. I have selected the output type as 3 = data base file. After this if I take a F5 I can see the Average, But when I actually runs the query, the average is not coming. If I select output as printer, I can see the average. But the requirement is to send the report as .CSV format. So I need the result in Database itself. Please help me
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!