
1. Re: Please help me to edit this calculation....cam
sabiha mahboob Jan 17, 2014 7:39 AM (in response to sabiha mahboob)I have tried below, but 'Cons' function is not working...:(
if attr([Facility/Non Facility])='Sum' then sum([Achieved Number])
ELSEIF attr([Facility/Non Facility])='Cons' then MAX([Achieved Number])
ELSE sum([Achieved Number] )/3
end

2. Re: Please help me to edit this calculation....cam
Tracy Rodgers Jan 17, 2014 10:26 AM (in response to sabiha mahboob)Hi Sabiha,
The calculation can be edited to be similar to the following:
if attr([Facility/Non Facility])='Sum' then sum([Achieved Number])
ELSEIF attr([Facility/Non Facility])='Cons' and datepart('month', max([Order Date]))=window_max(datepart('month', max([Order Date]))) then MAX([Achieved Number])
ELSE sum([Achieved Number] )/3
end
Hope this helps!
Tracy

3. Re: Please help me to edit this calculation....cam
sabiha mahboob Jan 18, 2014 1:29 AM (in response to Tracy Rodgers)Dear Tracy,
Thank you so much for writing me back, but its not working :(.
I have arranged my data in quarter view in the form of table.My requirement is when i look that dashboard it should follow all the three criteria of sum, average and const, but in the next dashboard the same data is in bar charts and that's aggregated to year wise so there i want sum for 12 months for few achieved numbers and for few achieved number max figure out of the 12 months and for few divides by 12(where it divided by 3 in previous quarter wise table).
Any suggestion?
Thanks
Sabiha