SET analysis syntax problem

[#1]

I´m trying to use this

round((count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR))/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR))*100,0.1 & '%' 

but there is a problem somewhere at the end???????

[morganaaron]

Is 0.1 your step for rounding? If so, you need to remove the second bracket after JOURNALNR and put a bracket after the 0.1.

[#3]

why you need parenthesis around the first count, remove it. That makes it cleaner.

[Anonymous]

Here it is:

if you want to perform round for first part below is the one.

=round(count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR))/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR)*100,0.1 & '%'

if you want to perform round for whole then below:

=round(count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR)/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR))*100,0.1 & '%'

and I don't understand why you kept 0.1 you can remove it if not required

Hope this helps.

BR,

Chinna

[jagan]

Hi,

Check this expression below

=round((count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}SJOURNALNR)/count({<AAR={'2014'},Gruppe={'Indbrud i beboelse'} >}JOURNALNR)*100),0.1) & '%'

Regards,

Jagan.