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 Send Private Message
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.