Div 0 problem 1

[Joshy]

Hi everyone, here a easy one... I got a expression in a query that goes
Gas Efficiency: [Energy Flow]*100/([Total Flow]*[Gas used])
On occasion the [Gas used] is none and of course the "div 0" error occurs.
Instead of filtering out that row of data completely, I want a dash (-) or (N/A) in the Gas Efficiency row whenever no gas is consumed.
what can I do?
thanks
josh

 

[RoyVidar]

Hi!

Try:
iif(len([Gas used]& &quot;&quot<>0;[Energy Flow]*100/([Total Flow]*[Gas used]);&quot;-&quot

Roy-Vidar

 

[ghubbell]

Lets see if it's easy:

GasEfficiency:IIF([Gas Used] = 0, [Energy Flow]*100/([Total Flow],[Energy Flow]*100/([Total Flow]*[Gas used])

Give it a go....(total flow must also always have a value other than 0...!?!
Gord
ghubbell@total.net