convert if statement to set

[#1]

Hi, I wonder if its possibel to create a set expression of the below if statement ?

if

(GetSelectedCount(Week), 
sum({$<KEY_ID={'work prel'}>} [Accounted quantity]),
if(sum({$<KEY_ID={'work}>} [Accounted quantity]) = 0
,sum({$<KEY_ID={work prel}>} [Accounted quantity])
,sum({$<KEY_ID={'work'}>} [Accounted quantity]))

)

[pover]

You could create a variable vKEYID that is equal to the following:

=if(GetSelectedCount(Week) or sum({$<KEY_ID={'work'}>} [Accounted quantity]) = 0,'work prel','work')

and then the expression would be:

sum({$<KEY_ID={'$(vKEYID)'}>} [Accounted quantity])

Regards, Karl

[#3]

Hi, Is that soultion more time efficient for the user ?

[pover]

To me it is alot cleaner y easier to write and maintain.  I don't know if it is easier to understand and I don't think it will calculate is less time.  The only way to find out is by testing it.

Karl