ANALYTICALVIEW AND CALCULATIONVIEW

[Former Member]

There is a small difference between US Actual Total value from the Analytical view Vs the Calc.View.

(ACTUAL) AN_COPA_COPY1 -       US total :- 1,407,676,309.62

CV_ACTUAL_PLAN_COPA_DATA1 US total :- 1,407,640,695.86

WHY IT IS SHOWING THE DIFFERENCE VALUES IN ANALYTICALVIEW AND CALCULATIONVIEW

[Former Member]

I need to verify your logic.

We need check, what the joins you have applied.

If you have applied Referential Join, you have ensure whether it fulfills referential integrity? Other wise you will get wrong result.

[Former Member]

It depends on lot of things.

Are you checking the values with same aggregation?

What is the logic involved to calculate result for this column?

Have you applied any filters?

[former_member226419]

Can you please share your logic how you are calculating the same?