a. Append the day of the week purchases were paid (DAY_PAID) in a virtual column added to Accounts Payable. Summarize on DAY_PAID to obtain total purchases paid and average for each of the 7 days of the weekSunday (Day 1) through Saturday (Day 7). Submit this schedule. In performing this step, make sure that your date field is in the proper format (YYYYMMDD).

What equation would I use for this in IDEA?

CASH in PAYEE name Prope SUPPNO PAYEE INVOICE INV DATE AMOUNT CHECK PAY DATE AUTH Equation Editor 4 M100 The Cash Co Inc 784566 Equation W007 CASH & CO | LD35622 .-. = + - * / . AND OR NOT MOD EXP | o @Functions Matching Conditional Custom Functions Date / Time The Matt Cash Co They are very similar in Mett Cash & Co In379-97 Each Function calculates a GR13297Test Equatiorn Maurice Mymah IN-39217 Record Number parameters passed to the Chimps Teaparty 14786SCT Field en Character (Amount) will round a field called "Amount to the PAYEE 3501050INVOICE Character 12 INV DATE AMOUNT 23 45678 34567 23456 CASH in PAYEE name Prope SUPPNO PAYEE INVOICE INV DATE AMOUNT CHECK PAY DATE AUTH Equation Editor 4 M100 The Cash Co Inc 784566 Equation W007 CASH & CO | LD35622 .-. = + - * / . AND OR NOT MOD EXP | o @Functions Matching Conditional Custom Functions Date / Time The Matt Cash Co They are very similar in Mett Cash & Co In379-97 Each Function calculates a GR13297Test Equatiorn Maurice Mymah IN-39217 Record Number parameters passed to the Chimps Teaparty 14786SCT Field en Character (Amount) will round a field called "Amount to the PAYEE 3501050INVOICE Character 12 INV DATE AMOUNT 23 45678 34567 23456