topic Syntax Error : help in QlikView

Syntax Error : help

Mon, 18 Apr 2011 11:59:30 GMT

Hi all,

Can anyone tell me where am i going wrong in this :

=num(sum([Payment Count])/(sum(IF([Billing Type]='Regular',([Bill Count]),0),'#,##%')))

Thanks in advance

Syntax Error : help

erichshiino — Mon, 18 Apr 2011 12:04:33 GMT

It's the order you closed the ()'s

Try this:

=num(

sum([Payment Count])/

(

sum(

IF([Billing Type]='Regular',([Bill Count]),0)

) )

,'#,##%')

Syntax Error : help

amars — Mon, 18 Apr 2011 12:05:32 GMT

Try this

=num(sum([Payment Count])/(sum(IF([Billing Type]='Regular',([Bill Count]),0))),'#,##%')

Syntax Error : help

Mon, 18 Apr 2011 12:12:45 GMT

Thanks that worked.

Can u also help me with this please?

(sum ([Payment Count]))/( sum(if([Billing Type]='Regular',[Bill Count],0)*(100)))

Syntax Error : help

erichshiino — Mon, 18 Apr 2011 12:24:23 GMT

It's basically the same, isn't it?

We can just adapt the previous one, and multiply it (or divide by 100) outside of the sums.

=(

sum([Payment Count])/

(

sum(

IF([Billing Type]='Regular',([Bill Count]),0)

)*100 )

)