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 Accor. The accounting team needs a clean payments report for reconciliation. Some payment records have null card brand values (for cash, wallet, and bank transfer payments), and the team wants all amounts properly rounded. They also need a net amount column that shows how much revenue was actually retained after refunds, with any negative values replaced by zero to avoid confusing downstream reports.
You are a Finance Data Analyst at Accor. The accounting team needs a clean payments report for reconciliation. Some payment records have null card brand values (for cash, wallet, and bank transfer payments), and the team wants all amounts properly rounded. They also need a net amount column that shows how much revenue was actually retained after refunds, with any negative values replaced by zero to avoid confusing downstream reports.