Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transformer and Division By Zero ???

Status
Not open for further replies.

mjcotter

Programmer
Jul 9, 2001
66
US
I've inserted a calculated Measure into my Transformer Model. The calculation is a simple division

A / B

My problem is that B could be zero in some cases.

Is there a way to expand my calculation to say

If B <> 0, then A / B
Else NULL

Or, is there another way to code for divide by zero possibilities?

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top