I have defined the formula in Account dimension. (Eg. Rate * Units)
The result of the formula is coming properly when I am drawing Monthly report. But I am not getting proper result when I am drawing report for Total Year. It accumulates the Rates of 12 months and Units of 12 months and then calculates the multiplication for Total Year.
Can anyone help me on this issue.