Syntax Error : help

[#1]

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

[erichshiino · Accepted solution]

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

Try this:

=num(

sum([Payment Count])/

(

sum(

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

) )

,'#,##%')

[amars]

Try this

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

[#4]

Thanks that worked.

Can u also help me with this please?

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

[erichshiino]

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 )

)