View Single Post
Old 02-14-2023, 12:33 PM   #5
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,121
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by ownedbycats View Post
Oddly enough, my purchase cost column does.

Attachment 199742

Template:
Spoiler:

Code:
program:
	switch_if(
		$$#purchasecost == 'none', '',
		$$#purchasecost ==# '00.00', '$0.00',
		$$#purchasecost <=# '00.99', '$0.01 - $0.99',
		$$#purchasecost <=# '04.99', '$1.00 - $4.99',
		$$#purchasecost <=# '10.00', '$5.00 - $9.99',
		$$#purchasecost <=# '15.00', '$10.00 - $14.99',
		$$#purchasecost <=# '15.00', '$10.00 - $14.99',
		$$#purchasecost <=# '20.00', '$15.00 - $19.99',
		$$#purchasecost <=# '30.00', '$20.00 - $29.99',
		'$30.00 and up' 
	)
Because that is a Numeric field and the other is Alpha-numeric. the sort/alignment is natively different, which is why we pad series index in templates
theducks is offline   Reply With Quote