About BETO

BETO · ‎09-04-2014

Hi KSharp, is is there a way we get only what was schedule and compare it to what was actual? for example have the table schedule but only use the date of week that is in the actual table sschedule S M T W TH F S ACTUAL table Id. Date Time. Am pm a1. 08/26/14. 10:00 am since the date was on a Tuesday do my comparison only for that date? is there a way I can only use the date of week schedule an compare it to actual date process? fyi schedule table has over 7k records compare to a smaller sample from actual. So when I merge it show s all the 7k records is there a way only to show records for the date in actual ? Thanks again for your help

BETO · ‎09-03-2014

Hi Ballardw, The data looks like this ID. COMPLIANCE. Date. Code A1. yes 08/14/14. A A2. Yes. 08/15/14. B A1. No. 08/15/14. A a2. No. 08/14/14. B a1. Yes. 08/16/14. A output I Need the date to be column I need the compliance to be sum an breack out of yes an no... I need the count of ID ... Thanks for your assitance

BETO · ‎08-29-2014

Thank you Tom, I was not aware of the When statement I used your example an tweak it to make it work for me and it did again thank you

BETO · ‎08-29-2014

HI Tom , thanks for for the quick response I actually have 4 if statement to take into consideration every possibly for example sum=. That gives me Results =notcompleted order=. But plus$ is > 1. than results = wrong type fOr A option to work the tech had to put something in sum and he had to put something in Amt if they are equal than it was completed if I use Not equal it will use In the results " wrong type" because sum is the sum of order and Plus$... so I need to look at the sum to see if its greater or less than Amt ...I hope that makes sense

BETO · ‎08-28-2014

Sorry i provided data that confuse my question. my table sUm Amt. Results 124. 125. A 145. 130. A my attempt is to determine if "sum "is greater or lesser than than "amt ".. If it is than its A ....if it's not the other if statements that I have will proceed...The one giving me issue is greater and lesser thanks again

BETO · ‎08-28-2014

Hi I need help with an if statement tables is as follows ID. Sum. Amt. Results A1. 120. 119. A a2. 125. 130. A a3. 126. 126. C iif sum =. Then results. "Notcompleted"; if sum >1 and amt ne sum = "A"; if order =. And plus money => 1 then sum= "e"; else sum ="c" the issue I'm having is the if statement for A some number greater than 0 has to be in Sum an a number has to be I. amt to do comparison of <> the 2 if statements work thanks again

BETO · ‎08-28-2014

HI Ballardw, your right sorry my question was incomplete What the table should look like is like this not reported and report is sum of occuerance .... 08/25/14 apple 2. 39. 22. 7. Uniq count (Not reported) Not report. Reported Unqui count (reported) A1. 1 34. 12. 3 a2. 1 5. 20. 4 a3. 0. 0. 0 I hope that helps

BETO · ‎08-28-2014

HI I a have a question on a transpose i have a table that looks like this BRanch. Name. Date. Compliance. a1. Apple. 08/25/14. Reported a2. Apple. 08/25/14. Reported a3. Mustard. 08/25/14. Not reported a3. Mustard. 08/26/14. Reported the transpose table I would like it to look like group Name 08/25/14. 08/26/14 branch. Count. total Reported. Not reported . Count. total Reported. Not reported a1. 1. 1. 1 a2. 1. 1. 1 a3. 1. 1. 1. 1. 1. 1 The count / total will change as there is more entries thank you again

BETO · ‎08-27-2014

HI I need assistance on this ad hoc request . i have two tables one has schedule and the other is the actual shipment date ... schedule table looks like this 1= No Schedule 2=AM 3=PM ID. Mon. Tue. Wed Thur. Fri Sat sun A1. 1. 1. 1. 2. 1. 1. 1 A2. 1. 3. 1. 1. 1. 1. 1 A3. 1. 2. 1. 1. 1. 1. 1 Second table Actual ID. Date. Time. AM/PM A1. 08/25/14 10:00 AM A2. 08/25/14. 13:00 PM A3. 08/25/14. 14:00 PM I need to look at actual table an compare it to schedule table to see if it was in compliance ID. Date. Time. AM/PM. Compliance A1. 08/25/14 10:00 AM YES A2. 08/25/14. 13:00 PM YES A3. 08/25/14. 14:00 PM NO Thanks

BETO · ‎08-21-2014

hi ballardw, i put in the code and I'm getting a error on f2. Something about formatted error thanks again

BETO · ‎08-21-2014

HI, i have a report where I need to determine the time if its AM or PM .For example I have time. ID 13:54 id1 10:33 Id2 i need to look at the time an determine if its AM like id2 is or PM like id1 is... The time is at military time ... In addition the number is coming in as a character thAnks for your assistance

BETO · ‎06-26-2014

THe only target is that some stores need to be Done AM or PM .The second table will have the time is as a date time

BETO · ‎06-26-2014

Im working on a table that houses schedule of service by AM or PM this is how table is formatt store # M T W TH FR SAT SUN 1. A. 2 P 3. A i will get a sec table that shows actually deliver timestamp store. Time 1. 1:23 pm 2. 3:33 pm 3. 9:00 AM I need to compare 1st table with 2 nd table to determine if the time delivery was made was at am or pm.. in the example I provided the 1st one is out of compliance since it was done at pm when it should be done at am

BETO · ‎06-18-2014

I m pulling data from a SQL server and the date is coming in formatted date9. ...the issue that I'm having is that i need to bring in whole records I tried filtering for yesterday date but I get error message saying = is different kind of data sets. when I ping the original table I can filter the same colmn by date.... Thank you for any assistance

BETO · ‎06-18-2014

Never mind I fig I was missing a ; it works thanks

Online Status	Offline
Date Last Visited	‎03-13-2020 05:49 PM

Re: How to drop a variable when criteria is met

How to drop a variable when criteria is met

Re: How to apply macro to proc sql ?

Re: How to apply macro to proc sql ?

How to apply macro to proc sql ?

Re: ID the day of week

Re: ID the day of week

Re: ID the day of week

Re: ID the day of week

ID the day of week

Re: How to ID min max

Re: How to ID min max

Re: How to use date/time field with a minus 1 day

Re: Best way to import Access Table?

How to adjust for 100%?

Re: How to use date/time field with a minus 1 day

Re: Assistance with transpose

Re: Between start and end

Re: Schedule Compare Actual shipment Time

Re: Assistance with transpose

Re: If this greater than or less than <>

Re: If this greater than or less than <>

Re: If this greater than or less than <>

If this greater than or less than <>

Re: Assistance with transpose

Assistance with transpose

Schedule Compare Actual shipment Time

Re: Determining the AM/PM based on time

Determining the AM/PM based on time

Re: How to delivery done in the AM/PM

How to delivery done in the AM/PM

When date is not a date

Re: To extract Alpha/numerical from a sentence