8 Replies Latest reply: Jan 11, 2011 7:40 AM by Martin FAVIER

# Locking / Freezing an expressions.

Hello,

Im trying to create a table with 2 expressions. How ever i want 1 of those expersions to not change when i select different

dates. However the other should change. How can i lock 1 expression to not change with my current selection?

as you can see on the picture. When i select this month by expamle the first Realisatie should change but the second should stay @ 77,38%.

Any help?

Thanks you Luuk

• ###### Re. :Locking / Freezing an expressions.

Hi,

You have to use Set Analysis like this exemple :

`avg({1} Realisatie)`

• ###### Re. :Locking / Freezing an expressions.

Hey martin thanks for your quick responce.

How ever im scared i dont fully understand what your saying.

could you be a bit more specific?

• ###### Re. :Locking / Freezing an expressions.

Hi

sum

({1} Sales) }

• ###### Re. :Locking / Freezing an expressions.

Hey thanks for your quick responce,

this doesnt seem to work for me.

When i create it it looks like this.

sum

You think its bugs cause i use a var?

• ###### Re. :Locking / Freezing an expressions.

What is your expression for Realisatie ?

• ###### Re. :Locking / Freezing an expressions.

It is a quite long var.

` (SUM(IF(Bewerkingen.CODE > 1000, ProjectTime.TotaalUren)) + Count(Distinct IF(Bewerkingen.CODE = 1000 ,Date))) / ( SUM(IF(Bewerkingen.CODE <> 0002 AND Bewerkingen.CODE <> 0012 AND Bewerkingen.CODE <> 0017 AND Bewerkingen.CODE <> 0018 AND Bewerkingen.CODE <> 0019 AND Bewerkingen.CODE <> 0072 AND Bewerkingen.CODE <> 1000, ProjectTime.TotaalUren )) + Count(Distinct IF(Bewerkingen.CODE = 1000 ,Date)))`

• ###### Re. :Re: Re. :Locking / Freezing an expressions.

You can try this :

`(sum({1<Bewerkingen.CODE={">1000"}>} ProjectTime.TotaalUren) + Count( {1<Bewerkingen.CODE={1000}>} Distinct Date)) /(Sum({1<Bewerkingen.CODE-={0002,0012,0017,0018,0019,0072,1000}>} ProjectTime.TotaalUren)+ Count({1<Bewerkingen.CODE={1000}>} Distinct Date))`

`<div></div>`

• ###### Locking / Freezing an expressions.

pls write set analysis like this

sum

({1} Realistie)