Calculated dimension including if condition

[#1]

Hi,

I need to write a calculated dimension which includes many if conditions.

What I want is to see data in Field I in dimension column if the calculated value(in if condition below) is smaller than or equal to 0.58. 

However I get an 'error in calculated dimension'.

What is wrong, please advise...

=if(

((((if(

(sum({ <[Field A]={50}>}  [Field B])

/

sum({ <[Field A]={50}>}  [Field C])) > 2, 2, (sum({ <[Field A]={50}>}  [Field B])

/

sum({ <[Field A]={50}>}  [Field C]))

))

+

(if(

(sum({ <[Field A]={50}>}  [Field D])

/

sum({ <[Field A]={50}>}  [Field E])) > 2, 2, (sum({ <[Field A]={50}>}  [Field D])

/

sum({ <[Field A]={50}>}  [Field E]))

))

+

(if(

(sum({ <[Field A]={50}>}  [Field F])

/

sum({ <[Field A]={50}>}  [Field G])) > 2, 2, (sum({ <[Field A]={50}>}  [Field F])

/

sum({ <[Field A]={50}>}  [Field G]))

)))/3)

*

(avg({ <[Field A]={50}>}  Field H)))

<= 0.58 , [Field I])

[lironbaram · Accepted solution]

change to

=aggr(if(

((((if(

(sum({ <[Field A]={50}>}  [Field B])

/

sum({ <[Field A]={50}>}  [Field C])) > 2, 2, (sum({ <[Field A]={50}>}  [Field B])

/

sum({ <[Field A]={50}>}  [Field C]))

))

+

(if(

(sum({ <[Field A]={50}>}  [Field D])

/

sum({ <[Field A]={50}>}  [Field E])) > 2, 2, (sum({ <[Field A]={50}>}  [Field D])

/

sum({ <[Field A]={50}>}  [Field E]))

))

+

(if(

(sum({ <[Field A]={50}>}  [Field F])

/

sum({ <[Field A]={50}>}  [Field G])) > 2, 2, (sum({ <[Field A]={50}>}  [Field F])

/

sum({ <[Field A]={50}>}  [Field G]))

)))/3)

*

(avg({ <[Field A]={50}>}  Field H)))

<= 0.58 , [Field I]) , [Field I])

[#3]

it works perfectly, thank u!

I need your help for another problem. now I need to add one more constraint for the same table:

if( [Field X]<= 6 and [Field A]= 80, [Field I] )

I could not combine this with the above.

Any idea?