Running total 1

[dinshak]

I have a running total named Pos. In the Evaluate section with a formula:

{SAMPLE.X_MON_LOCATION_ID} = 'POS_CTR_WAT'
OR
{SAMPLE.X_MON_LOCATION_ID} = 'POS_CTR_WAT_M'

I want to add to the abouve formula that when the "Pos" is empty fill in "NA" instead of leaving the field blank.

 

[lbass]

You would have to do that in a separate formula in the field explorer (formula->new):

if isnull({#pos}) then
"N/A" else
totext({#pos},0,"") //no decimals, no comma separator

Or you could select the running total->right click->format field->common tab->display string->x+2 and enter the formula above there.

-LB

 

[dinshak]

I did try the above by putting the formula in running total display string. It still does not display NA

 

[lbass]

You are right--using display string doesn't work. You can't format what isn't there, so you have to use my first suggestion.

-LB

 

[dinshak]

it works thank you. if i need to add the below with the above formula how can i do that

if isnull({#Pos}) then
"N/A" else
totext({#Pos}) //no decimals, no comma separator

if isnull({#NegL}) then
"N/A" else
totext({#NegL}) //n

 

[lbass]

Create two formulas:

//{@posneg}:
{#Pos}+{#Neg}

//{@displanposneg}:
if isnull({@posneg}) then
"N/A" else
totext({@posneg},0,"")//or add decimals if you wish

-LB

 

[dinshak]

It worked.

I have a formula field:
if isnull({@specs}) then {PRODUCT_SPEC.DESCRIPTION}
else {@specs}

when the report runs it displays the value
"11.1<=Resut<=19.5 days", but in one location its blank and it only displays when i double clik in the blank area.

I know this is a freaky situation but I do not have file storage

 

[lbass]

I have no thoughts on this.

-LB