Calculate
Divide
Divides one thing by another — numbers, or records period by period, for ratios such as days sales outstanding.
| Port | Side | What it carries |
|---|---|---|
numerator | In | What is divided — a number or records. |
denominator | In | What it is divided by — a number or records. |
out | Out | The ratio — a number if both sides were numbers, records otherwise. |
What you choose
Which side is which: the top port is divided by the bottom one.
Two choices sit on the card, and both start on auto:
- The period — day, week, month, quarter or year. When records are divided by records, this is the step they are lined up on.
- Balance or amount — whether balances are divided, or the amounts in each period.
What Fluidly decides
Divide adapts to what arrives.
| What you connect | What comes out |
|---|---|
| Two numbers | The ratio, as a number. |
| Records and a number | The records, each row divided by the number. |
| Records and records | One row per period, each the ratio of the two sides in that period. |
| Only a denominator | One over it — the 1 on top goes without saying. |
On auto the period is the coarser of the two sides: daily invoices divided by monthly revenue divide month by month. The card shows what auto landed on, as auto (month).
A period where the denominator is zero is left out; there is no ratio to give. Where one side has no row in a period, a balance carries over from the period before and an amount counts as zero.
Where both sides carry a headline figure, the headline of the result is those two divided — so the ratio's last row and its headline agree.
Example
ERP (receivables) → Divide → Multiply → Number, with ERP (sales) → Statistics (rolling sum) → denominator and Number (365) → Multiply: days sales outstanding, month by month.