Mastercard Interview Question: Formula Debugging Will this calculation work? IF [Category Name] = 'Cardio Equipment' THEN SUM([Sales]) ELSE null END

Notifications

Mastercard

Formula Debugging Will this calculation work? IF [Category Name] = 'Cardio Equipment' THEN SUM([Sales]) ELSE null END

Anonymous

Jun 1, 2024

No. Because: Cannot mix Agg and Non-Agg To fix it we can: We can remove Sum and Null (replace with 0) t