Template: Displaying only non-zero values

ownedbycats · 03-31-2021, 04:28 AM

Is this the best way to do it for a composite column?

Code:

program:
	x = $$#integer;
	if 
		x !=# 0 
	then
		x
	fi

ownedbycats · 03-31-2021, 04:56 AM

I noticed this displays 'none' for an undefined.

chaley · 03-31-2021, 05:02 AM

Quote:

Originally Posted by ownedbycats

Is this the best way to do it for a composite column?

Code:

program:
	x = $$#integer;
	if 
		x !=# 0 
	then
		x
	fi

That works fine, but I would use

Code:

cmp(t = $#myint, 0, t, '', t)

chaley · 03-31-2021, 06:17 AM

Quote:

Originally Posted by ownedbycats

I noticed this displays 'none' for an undefined.

It doesn't for me. The 'none' value gets turned into zero for arithmetic comparisons so you should see only numbers in the 'then' clause.

But after the 'if' the variable 'x' will contain 'none'. If you don't want that then use

Code:

x = raw_field(#myint', 0)

ownedbycats · 03-31-2021, 09:58 AM

Quote:

Originally Posted by chaley

That works fine, but I would use

Code:

cmp(t = $#myint, 0, t, '', t)

That's a lot simpler.

thank you

MarjaE · 04-15-2021, 11:54 PM

Hi, I have a #ratio column:

program: format_number(divide(booksize(),add(raw_field("#pa ges"),1)),"{0:,.0f}")

How could I amend that to avoid showing values of 0 or none?

chaley · 04-16-2021, 04:09 AM

Quote:

Originally Posted by MarjaE

Hi, I have a #ratio column:

program: format_number(divide(booksize(),add(raw_field("#pa ges"),1)),"{0:,.0f}")

How could I amend that to avoid showing values of 0 or none?

I don't know what version of calibre you are running so I am using the older syntax.

Code:

program: 
	s = divide(booksize(),add(raw_field("#pages"),1));
	cmp(s, 0, '', '', format_number(s,"{0:,.0f}"))

MarjaE · 04-23-2021, 04:37 PM

Thanks. I got mixed up, the tricky one is #pages which uses the Count Pages plugin.

03-31-2021, 04:28 AM	#1
ownedbycats Custom User Title Posts: 10,948 Karma: 74999999 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Template: Displaying only non-zero values Is this the best way to do it for a composite column? Code: program: x = $$#integer; if x !=# 0 then x fi Last edited by ownedbycats; 03-31-2021 at 04:35 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using built-in template functions in a custom template function	ilovejedd	Library Management	4	01-28-2018 12:20 PM
Use column values to determine author link template?	eosrose	Calibre	3	08-24-2013 12:34 AM
Display template values not saved to metadata.calibre	meme	Devices	2	02-13-2011 01:27 AM
displaying multiple values in the same column beneath each other	Firedancer885	Calibre	2	11-27-2010 03:13 PM

03-31-2021, 04:56 AM	#2
ownedbycats Custom User Title Posts: 10,948 Karma: 74999999 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I noticed this displays 'none' for an undefined.

04-15-2021, 11:54 PM	#6
MarjaE Guru Posts: 937 Karma: 53902736 Join Date: Jun 2015 Device: multiple	Hi, I have a #ratio column: program: format_number(divide(booksize(),add(raw_field("#pa ges"),1)),"{0:,.0f}") How could I amend that to avoid showing values of 0 or none?

04-23-2021, 04:37 PM	#8
MarjaE Guru Posts: 937 Karma: 53902736 Join Date: Jun 2015 Device: multiple	Thanks. I got mixed up, the tricky one is #pages which uses the Count Pages plugin.

Advert

Advert