Performing a Calculation with a Roll-Up table as denominator

Comments

2 comments

  • Avatar
    Michael Becker

    Hi Weston,

    what I would propose doing is allocation of machines total time per each entry in log. You could take machine 21 time 727, and calculate individual time allocation per log line per date. So in you case then it will be 727/3, then lookup this value back to log, and then use SUM on it to get proper total down the line from fact table alone. If you would like to discuss details of that, feel free to reach out to me at michael.becker@qbeeq.pl and I could help you sort it out.

    Regards,

    Michał Becker

    0
    Comment actions Permalink
  • Avatar
    Weston Olmstead

    Michael,

    That is an excellent solution and I think it will work well for my purposes. Thank you for bringing it to my attention!

    0
    Comment actions Permalink

Please sign in to leave a comment.