This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Finance Data Analyst at Salesforce. The invoicing system stores all monetary values in cents (integer format) to avoid floating-point precision issues. For reporting and dashboards, the finance team needs these values converted to dollars. Your task is to normalize all cent-based columns to dollars and compute the outstanding balance for each invoice.
You are a Finance Data Analyst at Salesforce. The invoicing system stores all monetary values in cents (integer format) to avoid floating-point precision issues. For reporting and dashboards, the finance team needs these values converted to dollars. Your task is to normalize all cent-based columns to dollars and compute the outstanding balance for each invoice.