To identify invoices that exceed the credit limit, first open a new Tableau workbook, connect to the accounts receivable file, and name the first worksheet (tab) in the workbook Exceed Credit Limit.
To identify invoices that exceed a customer’s pre-approved credit limit, we will create a new measure called Difference. Right click under Measures and click on Create Calculated Field.
In the popup window, change the variable name from Calculation1 to Difference.
In the white space, type this formula: [Invoice Total]-[Credit Limit] and click OK. This will create our new variable under Measures that identifies yet-uncollected sales invoices that exceeded the credit limit.
Add Difference to the Rows line.
Right-click on Invoice No and convert it to a Dimension.
Add Invoice Number to the Columns line, and then sort in descending order of magnitude (click on sort icon at the top of the toolbar).
Take a minute and think about what the negative values represent (hint, look back at the formula used to create the Difference measure)? Because of how we have calculated the measure, negative values are invoices that are less than the credit limit.
Now, add a filter on Difference to remove invoices with negative values (hint: set the minimum to 0).
How many invoices exceed the credit limit?
To identify invoices that exceed the credit limit, first open a new Tableau workbook, connect to the accounts receivable file, and name the first worksheet (tab) in the workbook Exceed Credit Limit. To identify invoices that exceed a customer’s pre-approved credit limit, we will create a new measure called Difference. Right click under Measures and click on Create Calculated Field. In the popup window, change the variable name from Calculation1 to Difference. In the white space, type this formula: [Invoice Total]-[Credit Limit] and click OK. This will create our new variable under Measures that identifies yet-uncollected sales invoices that exceeded the credit limit. Add Difference to the Rows line. Right-click on Invoice No and convert it to a Dimension. Add Invoice Number to the Columns line, and then sort in descending order of magnitude (click on sort icon sort icon at the top of the toolbar). Take a minute and think about what the negative values represent (hint, look back at the formula used to create the Difference measure)? Because of how we have calculated the measure, negative values are invoices that are less than the credit limit. Now, add a filter on Difference to remove invoices with negative values (hint: set the minimum to 0). How many invoices exceed the credit limit?
