Division

[cjordan8]

I have two aggregate totals in the report footer that I would also like to divide so I can get a percentage. I built an expression that looked something like this.

=Sum([Competitors.Revenue])/Sum([EG.Revenue])

and it returns a value of #NUM. What's going on?

 

[cjordan8]

never mind...i'm an idiot.

 

[Ally]

Get rid of the extra Sum.

=Sum([Competitors.Revenue])/([EG.Revenue])

That should do it.