Hello
I have been working with Alteryx to create a Data Analytic App for the Audit Team where;
An app allows audit teams to upload client breakdowns of P&L and SOFP areas and select a sample (GAM compliant) using one of the below methodologies:
Random Non-statistical sampling
MUS Non-statistical sampling
Controls/Attribute sampling
High value scoping
Once you have selected the above ‘sampling method’ it will give the following options to be completed:
High value Threshold per Caseware sampling form – XXXX (blank box to be left) – details to be filled by audit team member completing the form
Random sample size per Caseware sampling form – XXXX (Blank box to be left) - details to be filled by audit team member completing the form
Once the form is fully completed, there is an option that states ‘Cancel’ or ‘Run’.
Once you click ‘Run’ the output will be in two forms: Excel format and PDF.
Currently I am facing difficult on which tool i should use when a sample is selected then their should be a display of Options for High VAlue Threshold but also Random Sample Size as Explained Above