Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>
Hi,
You have to use Set Analysis like this exemple :
avg({1} Realisatie)
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?
pls write set analysis like this
sum
({1} Realistie)Hi
U can use set anaylysis like bellow for your experssion.
sum
({1} Sales) }Hey thanks for your quick responce,
this doesnt seem to work for me.
When i create it it looks like this.
sum
({1} $(vBezettingsgraad))
You think its bugs cause i use a var?
What is your expression for Realisatie ?
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)))
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>