Search results for query: *

Here are the steps I took: 1) Created the new formula named it "Stops3" "whileprintingrecords; numbervar sumcnt := sumcnt + distinctcount({LABEL.LBSTOP}, {TRKEXTF.RHRTE}); 2) Click on Reports > Section Expert > group Header #1 TRKEXTF.RHRTE -A > SUPPRESS (No Drill-Down) > "X2" icon >...

LB, I'm getting the following error message after I place the first code in the RHRTE group section. "The Formula result must be a boolean" What do I need to change?

LB, I aplogize... I did not add the extra line to equal five stops. However it should be five for both groups it was just a quick example. The end result is the total of 10 stops. Madawc, Thank you for the link going to review in a few and the version I run is 11.5

Need some help with Summing (distinctCount) Formula 1: Sum (DistinctCount ({LABEL.LBSTOP}, {TRKEXTF.RHRTE})) Formula 2: Sum (DistinctCount ({LABEL.LBSTOP})) Error message "This Field Cannot be summarized" (PH) DPT Route Trn# Item# Pcs Stops (GH1) [Route] (D) DRY 101 12333 123213...

LB, The report was corrupt I redesigned it and it worked fine... Thank you!!

LB, Appreciate you helping me with this, below are the issues I'm having with your suggestion. Please advice... When I do the following: datediff("s",minimum({@Date Time},{POHHDR.PHHVNA}), maximum({@Date Time},{POHHDR.PHHVNA})) I get this ERROR "THE FORMULA RESULT MUST BE A BOOLEAN" When I...

I have a report that is grouped into PO's I need to take the time from the first transaction and from the last transaction from that PO and get a time difference. Any Help would be greatly appreicated. -Gus HAPPY NEW YEAR!!!

LB, Thank you for you help it worked perfectly plus you showed me feature I never knew was available. Your the best....

I have it grouped by user so how do I account for them in the formula? I just tried it and I'm getting all "TRUE" in the field.

LB, If you publish a book I'll buy it. It's working like a charm. However I got just one more request if I may. I need to use the select expert on this field but it does not come up. I'm sure it has to do with the formula. Is there a way we can get it were I can only view the ones with > 15...

The cursor was on "datetime(currentdate,{@POTIME}". First formula: //WhileprintingRecords; //WhileReadingRecords; //Local NumberVar ConvertTime := {PORCV.PORTIM}; // //Local NumberVar MyHours; //Local NumberVar MyMinutes; //Local NumberVar MySeconds; // //MyHours := ConvertTime \ 10000...

Almost... "Too many argument have been given to this function" that's the new error. what do you think?

Yes it has the following: WhileReadingRecords; Local NumberVar ConvertTime := {PORCV.PORTIM}; Local NumberVar MyHours; Local NumberVar MyMinutes; Local NumberVar MySeconds; MyHours := ConvertTime \ 10000; ConvertTime := ConvertTime mod 10000; MyMinutes := ConvertTime \ 100; MySeconds :=...

LB, I added the paren but I then get the following error "This field has no previous or next value". Please assist. datediff("s",datetime(currentdate, previous({@POTIME}),datetime(currentdate,{@POTIME})))

I copied the formula but it's giving me an error, "The ) is missing". Below is a copy of what I copied only change was the field. datediff("s",datetime(currentdate, previous({@POTIME}),datetime(currentdate,{@POTIME}))

Thanks for the tip I'll look into it.

I need to get the time difference from the "TranTime" field for each record in sequnce order; record 1 time differnce with record 2 then record 2 the time difference with record 3 so on and so on for all records through out the field. I have a productivty project were I need to identify the idle...

How do the Previous() and Next() functions work?

Here is the formula DateDiff ("n",{@STRT X} ,{@END X} )

I created the formula field below to use it with the "Select Expert" but when I try to select it, it does not display the "@Ovr" field. Is there another way of doing this? I would greatly appreciate any help? [Field name "@Ovr"] if {PIRUSER.USWHDP}= "DRY" AND {PIRTRAN.PTTASK}= "LUNCH" AND...