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)

hi GJPParket, after ELSE, there is still condition. CR won't allow the formula to be saved because it say that Local String etc...isn't part of the formula but obviously it is.

If {@sum_condition_value} > 0 Then
{@sum_condition_value}/10
Else
0

Local StringVar outstring := {@sum_condition_value};
If Left(outstring ,1) = '-' then
""
Else
CStr(Val(outstring ) * .1, 2)

0

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

In Crystal syntax if that is a single formula it is not part of the formula because the formula ends at the 0. To continue the formula you need a ; after the 0

This is the only formula you need as stated above by GJParker
If {@sum_condition_value} > 0 Then
{@sum_condition_value}/10
Else
0

You can then format it as a number and suppres 0s in the CUSTOM format.

If you want to do it with strings then
If {@sum_condition_value} > 0 Then
CStr({@sum_condition_value}/10,2)
Else
""

Why are you converting the summary to a string?
Try it this way

If sum ({Sheet1_.Condition value}, {Sheet1_.Bill#Doc#}) > 0 Then
sum ({Sheet1_.Condition value}, {Sheet1_.Bill#Doc#}) / 10
Else
0

Or if you really want to use strings
If {@sum_condition_value} = "0.00" Then
""
Else If Left({@sum_condition_value},1) = "-" Then
""
Else
CStr(Val({@sum_condition_value})/10,2)

Ah...what is the below which still part of the formula

Val

CStr

/10,2

Sorry for asking these very basic and annolying questions which I find very intriguing. (which You probably thinking I'm clueless...which you are probably right)

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Can any of the values be NULL?

What is this formula?

{@sum_condition_value}

mlmcc