Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It's the order you closed the ()'s
Try this:
=num(
sum([Payment Count])/
(
sum(
IF([Billing Type]='Regular',([Bill Count]),0)
) )
,'#,##%')
It's the order you closed the ()'s
Try this:
=num(
sum([Payment Count])/
(
sum(
IF([Billing Type]='Regular',([Bill Count]),0)
) )
,'#,##%')
Try this
=num(sum([Payment Count])/(sum(IF([Billing Type]='Regular',([Bill Count]),0))),'#,##%')
Thanks that worked.
Can u also help me with this please?
(sum ([Payment Count]))/( sum(if([Billing Type]='Regular',[Bill Count],0)*(100)))
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 )
)