Reports , enquiry

Dears

I want to create an enquiry that per each application LD,TT,FT,LA, to count this application by inputter. But the inputter has always a portnumber and a special caracter and the name who inputed the record example 456_emehaj, 34567_emehaj, 1_emehaj. As the number of port changed sometimes i one character, 2 or 3 i am not find the way how i can define only the name so only emehaj . So if i can achive to take only emehaj that i can sort the enquiry by user. Can nobody help on this , how i can fix it in the enquiry.

Best

Thanks a lot,

IT really work with FIELD.... I was trying with E"_",* but this not worked. So just to understand how it calculate. what it means FIELD so begin after the _ character take ?

And please if you can help , how to have just only a value like sum , for example we have more the one charges but how i can calculate both in one column like a total?

I supose you mean you have a transactions with 2 charges on it. Use the SUM function on the field that holds the amount of the charge:

THE.CHARGE = SUM(CHANGE(R.REC<FT/LD/TT.CHARGE.FIELD>,@VM,@FM))

Make sure they are all in the same currency and they actually have amounts, not EUR10.00 values.

Also in help it says enq suports:

TOTAL XXX Total enquiry field XXX.

Donno how to use this but it might be what you need.

hi

Yes i want for LD. but SUM FUNCTION have to use in rutine or Enquiry?

SUM can be used in a routine, but you should try to play a little with TOTAL option directly on the enquiry.