Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Syntax Error : help

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

1 Solution

Accepted Solutions
Partner
Partner

Syntax Error : help

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

Try this:

=num(

sum([Payment Count])/

(

sum(

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

) )

,'#,##%')

4 Replies
Partner
Partner

Syntax Error : help

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

Try this:

=num(

sum([Payment Count])/

(

sum(

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

) )

,'#,##%')

Highlighted
amars
Valued Contributor

Syntax Error : help

Try this

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

Not applicable

Syntax Error : help

Thanks that worked.

Can u also help me with this please?

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

Partner
Partner

Syntax Error : help

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 )

)