Skip to content
Gallery
Template Price Variations
DB Sand
Pricing Variations
More
Share
Explore

icon picker
Pricing Variations

→
[ ]
⁠
kg
Price As Of:
$ 0
⁠
⁠
Price Until:
$ 0
⁠
⁠
Pricing Variations
1
Name
Product
VolumeInKg
Price
pricePerKg
priceAsOf
priceUntil
1
1 | Sand $176.74 per 1,000 kg
Sand
1,000
$176.74
$0.177
1 | Sand $176.74 per 1,000 kg
1 | Sand $176.74 per 1,000 kg
2
2 | Sand $1,060.00 per 10,000 kg
Sand
10,000
$1,060.00
$0.106
1 | Sand $176.74 per 1,000 kg
1 | Sand $176.74 per 1,000 kg
3
3 | Sand $3,990.00 per 50,000 kg
Sand
50,000
$3,990.00
$0.080
1 | Sand $176.74 per 1,000 kg
1 | Sand $176.74 per 1,000 kg
4
4 | Sand $5,000.00 per 70,000 kg
Sand
70,000
$5,000.00
$0.071
1 | Sand $176.74 per 1,000 kg
1 | Sand $176.74 per 1,000 kg
5
5 | Sand $6,900.00 per 100,000 kg
Sand
100,000
$6,900.00
$0.069
1 | Sand $176.74 per 1,000 kg
1 | Sand $176.74 per 1,000 kg
There are no rows in this table
⁠
The view below shows how you can rewrite the content living in the table while adding an extra layer of content. The set up of the first list starting with 0001 requires insight in the composition of lists in general. A bit further down the details. You can do this in various ways, like using Sum() instead of +1.
⁠
0001 - 1,000 → $176.74
1,001 - 10,000 → $1,060.00
10,001 - 50,000 → $3,990.00
50,001 - 70,000 → $5,000.00
70,001 - 100,000 → $6,900.00
⁠
⁠

⁠
→
11,00110,00150,00170,001
⁠
⁠
Sequence(1,[DB Sand].Count()).ForEach(CurrentValue.WithName(Root,
ListCombine(1,Sequence(1,[DB Sand].Count()-1).ForEach([DB Sand].VolumeInKg.Nth(CurrentValue).
Nth(Root)+1))
)).First()

Please note that the writing does not instruct you how to calculate any outcome as written in my blog.
⁠
How to Coda Volume Based Pricing?
The more you buy the less you pay per unit
huizer.medium.com
⁠
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.