G
Guest
I have this T-SQL code:
CASE WHEN GrossIncome < 0 AND
NetIncome < 0 THEN - 1 * IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome,
0) * 100, 0)
ELSE IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome,
0) * 100, 0)
END AS [GP%]
And I'm trying to do the same thing on a form:
= If GrossIncome < 0 AND NetIncome < 0
THEN - 1 * IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome, 0) * 100, 0)
ELSE IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome, 0) * 100, 0)
but am getting errors. Basically I'm trying to prevent DIV0 errors.
many thanks
CASE WHEN GrossIncome < 0 AND
NetIncome < 0 THEN - 1 * IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome,
0) * 100, 0)
ELSE IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome,
0) * 100, 0)
END AS [GP%]
And I'm trying to do the same thing on a form:
= If GrossIncome < 0 AND NetIncome < 0
THEN - 1 * IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome, 0) * 100, 0)
ELSE IsNull(NULLIF (NetIncome, 0) / NULLIF (GrossIncome, 0) * 100, 0)
but am getting errors. Basically I'm trying to prevent DIV0 errors.
many thanks