
1. Re: Need to perform SUM on this calculated Field . Sum is disabled.
Matt Lutton Apr 13, 2018 10:56 AM (in response to satish.parvathaneni)It is likely already an aggregate  you may need something like a WINDOW_SUM or a FIXED LOD expression to return the sum of an aggregate  here is one post with some options: Total() vs Window_Sum()
Also look into FIXED LOD expressions: FIXED Level of Detail Expressions
Cheers!

2. Re: Need to perform SUM on this calculated Field . Sum is disabled.
Mike Mainzer Apr 13, 2018 12:10 PM (in response to satish.parvathaneni)See how it's colored blue? That means you have it as a discrete number.
Rightclick just like you're doing now and select 'Convert to Continuous'. Then you should be good to go.

3. Re: Need to perform SUM on this calculated Field . Sum is disabled.
satish.parvathaneni Apr 13, 2018 4:58 PM (in response to Mike Mainzer)I did try that . Below is the formula that i have used to derive . i need a running total on top of that ,but i can sum it either .
Final Projections =

IF [Aver] = 0 and SUM([Actual]) = 0 THEN
PREVIOUS_VALUE(0)+([Average])
ELSEIF SUM([Actual]) =0 and [Aver] <>0 THEN
[Aver]
ELSE
SUM([Actual])
END

4. Re: Need to perform SUM on this calculated Field . Sum is disabled.
Mike Mainzer Apr 14, 2018 6:22 AM (in response to satish.parvathaneni)Alright, first you have to convert it to continuous.
Once you do that, you can't perform an aggregation like sum or average on it because you already did so in the calculation itself. Instead of ending the calculation with SUM([Actual]), just end it with [Actual]. Now, your calculation ends with two possible options:
[Aver] or [Actual]
Now if [Aver] is already a calculated field that's been aggregated, you still won't be able to aggregate it once again. For example, if [Aver] is the result of a calculated field where you're saying to average something, it's already been aggregated.