#INF error in computed item

[tallbarb]

When dividing one item (bien) by another (budget) - which has a zero value - I get #INF in the computed results. Anyone know how I can show something other than that? I've tried an if...else but it didn't work - might have been user error, though.

if(bien/budget<0){0}else{bien/budget}

Thanks!

 

[kublait]

I think the system is interpeting your formula as (bien/budget)<0. If the value of budget is a zero then the results is an error rather than zero. Try your evaluation only on the budget value rather than the bien/budget value. Such as

if (budget<0){0} else (bien/budget)

Hope that helps