Author Topic: Recreate a Before Rollup calculation in Excel  (Read 138 times)

Offline cognox

  • Associate
  • **
  • Join Date: Sep 2018
  • Posts: 3
  • Forum Citizenship: +0/-0
Recreate a Before Rollup calculation in Excel
« on: 12 Oct 2018 07:09:24 pm »
Please see the attachment to get a better picture of the issue.

I am using a calculation as a measure which is set to Before Rollup in regular timing (in transformer). Result: 183,111 (Column C in attachment)
I have the same calculation as a measure set to After Rollup in regular timing. Result: 113,715 (Column D in attachment)
The results are different.
When I use the data to calculate the same formula in Excel, the result is the same as After Rollup. (Column E).

Is there a way to re-create functions of Before Rollup in Excel? I need to present and justify the difference for my clients. The difference is significant.