One amount in another currency in a column of amounts

currency-column-mixon by defaultJapanese / English

A lone amount in another currency in a column, such as ¥12,500 among dollars

Example

Flagged

| Charge | Amount | | --- | --- | | Ocean freight | $640.00 | | Marine insurance | ¥12,500 | | Documentation fee | $40.00 |

What chaff prints

4:22 "Marine insurance" is written "¥12,500", in another currency than the rest of its column ("$640.00")

Fixed

| Charge | Amount | | --- | --- | | Ocean freight | $640.00 | | Marine insurance | $85.00 | | Documentation fee | $40.00 |

What chaff prints

no finding

How to fix

Convert the amount to the column's currency, or, if it really is paid in another currency, name the currency in the row's label or the column's heading ("Marine insurance (JPY)").

Why it matters

When one cell of a column of dollar amounts reads "¥12,500", the reader adds or compares it with the others without noticing it is in another currency. It happens when a row is copied from another quotation or a foreign invoice, or when an amount is not converted. For each column of a table, the currencies of its amounts are counted (¥ and yen are one currency); when at least two cells are in one currency and exactly one cell is in another, that cell is pointed out.

What it does not flag

A table with a column of currencies or of exchange rates (Currency, Exchange rate, FX, converted, equivalent), a column whose heading names two currencies ("Amount (JPY/USD)"), and a column with a cell that gives two currencies ("¥12,500 (USD 85)") are not reported. Neither is a column with fewer than two cells in one currency, with two or more cells in another, or with three currencies or more, a row whose label names that currency in brackets ("Transfer fee (JPY)"), or a column of bare figures with no currency. Whether ¥ is yen or yuan is not told apart.

Turning it off or relaxing it

Silence this one spot (in the document)

Relax it for the team (the reason is kept as a comment in chaff.yaml)

npx chaffjs relax currency-column-mix --why "reason"

Turn it off for the team (chaff.yaml)

rules: currency-column-mix: off

Technical details

Layer: L3
Status: stable
Severity: warning
Languages: Japanese and English
Suited to: business, technical, blog, legal, docs, academic, literature, speech

Levels

Set a level for this rule under rules in chaff.yaml. With nothing set, it runs at the level its genre gives it (see By genre below).

strict	error
normal	warning
relaxed	info

This rule has no limit to count to. A level sets how a finding is marked: relaxed keeps the finding and marks it a step lower.

By genre

Runs by default in: technical/spec, technical/readme, blog/tech, blog/essay, blog/owned-media, business/proposal, business/report, business/email, business/press-release, business/meeting-notes, legal/contract, legal/statute, legal/judgment, legal/patent, docs/manual, docs/faq, docs/glossary, academic/paper, speech/address, speech/transcript
Turned off by the genre in: literature/fiction, literature/essay, literature/poetry, literature/play

Genres

Message

"{item}" is written "{written}", in another currency than the rest of its column ("{usual}")

This page is built from the rule's definition file:packages/chaff/rules/currency-column-mix.yaml