Question: Use the DATE ( . . . ) function to add months to the previous audit date. Define a function NextAudit 2 _ CSA which
Use the DATE function to add months to the previous audit date. Define a function NextAuditCSA which
takes the business rule as a function argument.
NextAuditCSA has the arguments as shown in this LAMBDA:
LAMBDAlastaudit,companysize,auditresult,businessrule,LET
where businessrule is defined by the above LAMBDA. Make use of the LAMBDA helper function MAP
to implement NextAuditCSA.
The rules are:
If a firm is large and failed, their next audit is in two months.
If a firm is large and passed, their next audit is in three months.
If a firm is small, their next audit is in four months
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
