# 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),'#,##%')))

1 Solution

Accepted Solutions 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

## 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
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

## 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 )

)