Calculate Daily productivity in dollars which table

Sort:
You are not authorized to post a reply.
Author
Messages
Healthcare User
New Member
Posts: 4
New Member
    I am working in a healthcare on ETL tools, now a requirement assigned to me, is to calculate the daily productivity on each day basis dollar amount. Could you please provide some details on tables.

    I am currently looking at GLTRANS table based on fiscal year, account, sub_account.
    But acct_amount and trans_amount fields are showing values zeros mostly and Units_amount has values. which field value should i sum to calculate daily productivity?



    select fiscal_year, acct_period, account, sub_account, units_amount, acct_amount, trans_amount, posting_date from PROD.GLTRANS


    Thanks a lot for the helpful info.
    You are not authorized to post a reply.