Calculate Daily productivity in dollars which table

 0 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
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.