Hi all

Can anyone please tell me how to separate -ve values or +ve values from a sum column/define/compute column.

i was trying by below wise

TABLE FILE TTTTT
SUM
TOT
BY ID AS 'ID'
BY Name AS 'Name'
HEADING
"Credit Balances Listing(All Students) As on"
FOOTING
"&DATEtrMDYY <+0> WHERE ( ENTRY_DATE GE DT(&EntryDate_From) ) AND ( ENTRY_DATE LE DT(&EntryDate_to) ) AND ( TOT LT 0 );

but when i was trying to do by that it is not separating the -ve values

Please help me out

Thanks
Regards
Anish

Well, I don't know what +ve and -ve are but the first thing I would recommend is that you change the name of the field TOT to something else. TOT would be considered 'reserved' as it is a WebFOCUS prefix operator.

So let us call it for purposes of discussion ID_TOTS.

So then where you have AND (TOT LT 0), change this to:

WHERE TOTAL ID_TOTS LT 0

See if that works.

Ginny

Its not working by that way
Is there any other way to do?
It will be very helpful

Thanks
Anish

I suppose -ve and +ve are the negative and positive values?

Anish,

Can you do a PRINT on that TOT column and show us some of the values. Also, what is the format of the field in the master file description?

I think we are have trouble understanding the -ve and +ve stuff.

Ginny

I am sorry
-ve ------ Negative
+ve ------- Positive

Thanks
Anish

you're missing a (") at the end of your text in your footing statement.

try this

DEFINE FILE CAR
TOT/D13.2 = RCOST ;
END
TABLE FILE CAR
SUM TOT
BY COUNTRY
FOOTING
"THIS IS THE END

Hi all

I just want to write my query in clear way once again.

I have created one Define or compute field which contains negative values and positive values, so i want to show this define or compute field and also the new column with only negative values from the first define or compute field.

Please help me out

Thanks
Regards
Anish

Please give us the format of the TOT field. If it is alpha and not numeric, what you are currently doing will not work.

Ginny,

It is not working

The tot format is D15.2

As i said above i have to separate the negative values but the first define field is summed
How i can check condition for summed column?

Thanks
Regards
Anish

Use a COMPUTE instead of a DEFINE. A COMPUTE is done on the internal matrix after all the data has been processed.

Or you can do a WHERE TOTAL test.

Also please change the name of the TOT field as I recommended above.

Ginny

I have changed tot to Curr_tot.
i have used compute instead of define.
How to USE sum function in compute field?

Thanks
Regards
Anish

Anish,

You really need to get some training or read the manuals, especially "Creating Reports with the WebFOCUS Language. Some of this is really basic stuff. Reading the manual will give you an idea of what you can do with the product.

Try this.

 TABLE FILE TTTTT
SUM CURR_TOT
BY ID AS 'ID'
BY Name AS 'Name'
HEADING
"Credit Balances Listing(All Students) As on"
FOOTING
"&DATEtrMDYY <+0> 
WHERE ( ENTRY_DATE GE DT(&EntryDate_From) ) AND ( ENTRY_DATE LE DT(&EntryDate_to) );
WHERE TOTAL CURR_TOT LT 0 ; 
END

But to answer your question, if your verb is SUM, your COMPUTE will be summed. If your verb is PRINT, your COMPUTE will be printed.

Ginny

I am sorry, but i already tried with that i am getting abnormal result.....

Even i will try once

Thanks
Anish

What abnormal result are you getting?

TABLE FILE CAR
SUM SALES 
BY COUNTRY
WHERE TOTAL SALES GT 50000
END  

If you run this without the WHERE TOTAL, you get all the sales. With it, you only get two.

Isn't this what you are trying to do?

Ginny

Yes, i am trying with compute and wheretotal, and now i am doing data mining, whether i have any problems with the data.


Thanks
Regards
Anish

If I understand you correctly, you want to have a column with the defined positive or negative value, and also a column with just the negative values. Is that correct?
If so then consider the next example code:

DEFINE FILE CAR
DEFFLD1/D8  = IF SEATS LT 4 THEN -DCOST ELSE RCOST;
DEFFLD2/D8S = IF DEFFLD1 GE 0 THEN 0 ELSE DEFFLD1;
END
TABLE FILE CAR
PRINT CAR MODEL SEATS DEFFLD1 DEFFLD2
BY COUNTRY
END
TABLE FILE CAR
SUM CAR MODEL SEATS DEFFLD1 DEFFLD2
BY COUNTRY
END

Would this be of any help to you?