Solved

# Formula issue?

Posted on 2011-03-06

Hi CR guru

The below formula produces 0.00 if has not value and I cannot find a feature in CR to supress if Zero value. If you amend the formula to produce a BLANK outcome rather than 0.00, what would the formula be? I think the way the formula field formatted is not number hence the feature 'supress value if zero' isn't available?

if Val( {@sum_condition_value} ) <= 0 then

""

else

Local StringVar outstring := {@sum_condition_value};

If Left(outstring ,1) = '-' then

""

Else

CStr(Val(outstring ) * .1, 2)

Thanks heaps