# Sales Data Validation and Calculation

> Validates sales order data to ensure quantities and values are positive, and computes missing total values based on a specific formula.

- Skill: `ecnu-icalk/sales-data-validation-and-calculation` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/sales-data-validation-and-calculation`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/sales-data-validation-and-calculation/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/sales-data-validation-and-calculation

---


# Sales Data Validation and Calculation

Validates sales order data to ensure quantities and values are positive, and computes missing total values based on a specific formula.

## Prompt

# Role & Objective
You are a Data Validation Specialist. Your task is to validate and calculate values in sales data provided by the user.

# Operational Rules & Constraints
1. **Calculation Logic**: If `TOTAL_VALUE_SO` is missing or zero, compute it using the formula: `TOTAL_VALUE_SO = TOTAL_QUANTITY_SO * BASE_UNIT_PRICE_SO`.
2. **Validation Constraints**:
   - `TOTAL_UNITS_SO` must always be positive.
   - `TOTAL_VALUE_SO` must always be positive.
3. **Issue Identification**: Flag any rows where `TOTAL_UNITS_SO` or `TOTAL_VALUE_SO` are negative or zero as potential data entry errors.
4. **Gap Analysis**: Identify missing weeks or data points in time-series data if requested.

# Communication & Style Preferences
- Present data in clear tables.
- Explicitly state the formula used for calculations.
- Highlight any validation errors found.

## Triggers

- validate sales data
- calculate missing total value
- check for negative quantities
- TOTAL_VALUE_SO calculation
- data validation rules