1 2 Previous Next 18 Replies Latest reply on Nov 20, 2017 12:18 PM by Diogo Braga Go to original post
• ###### 15. Re: EXCLUDE one dimension value from LOD FIXED Calc

{FIXED [School Code], [Metric]:MAX(

if [Metric]='FOODSERVICE' then 'No'

elseif [CF 17-18 16-17 Fall Strongly Agree Diff] = 'Red' and

[CF 17-18 Fall Strongly Agree Below CSUSA Avg] = 'Red' and SUM([17-18 Fall Agree & Strongly Agree]) <.6

or

SUM([17-18 Fall Disagree & Strongly Disagree]) > 0.1 then '⚑'

elseif [CF 17-18 16-17 Fall Strongly Agree Diff] = 'Green' and

[CF 17-18 Fall Strongly Agree Below CSUSA Avg] = 'Green' and SUM([17-18 Fall Agree & Strongly Agree]) >=.9

or

SUM([17-18 Fall Strongly Agree]) > 0.6 and SUM([17-18 Fall Disagree & Strongly Disagree]) <=.05 then ' '

else ' '

end)}

• ###### 16. Re: EXCLUDE one dimension value from LOD FIXED Calc

Thank you! I still get the error. See workbook attached.

• ###### 17. Re: EXCLUDE one dimension value from LOD FIXED Calc

Metric column has different values then food service. Please see screen shot.

I just changed one values in the calculation and it is working.

if [Metric]='Foodservice_Q1' then 'No'

else {FIXED [School Code], [Metric]:

if [CF 17-18 16-17 Fall Strongly Agree Diff] = 'Red' and

[CF 17-18 Fall Strongly Agree Below CSUSA Avg] = 'Red' and SUM([17-18 Fall Agree & Strongly Agree]) <.6

or

SUM([17-18 Fall Disagree & Strongly Disagree]) > 0.1 then '⚑'

elseif [CF 17-18 16-17 Fall Strongly Agree Diff] = 'Green' and

[CF 17-18 Fall Strongly Agree Below CSUSA Avg] = 'Green' and SUM([17-18 Fall Agree & Strongly Agree]) >=.9

or

SUM([17-18 Fall Strongly Agree]) > 0.6 and SUM([17-18 Fall Disagree & Strongly Disagree]) <=.05 then ' '

else ' '

end}

end

1 of 1 people found this helpful
• ###### 18. Re: EXCLUDE one dimension value from LOD FIXED Calc

Thank you!

1 2 Previous Next