Thread: Column Built from other Columns question
View Single Post
Old 09-11-2017, 02:04 PM   #1
abqkjh
Zealot
abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.
 
abqkjh's Avatar
 
Posts: 147
Karma: 1502780
Join Date: Mar 2013
Device: Moto e5
Column Built from other Columns question
I am a fairly unsophisticated Calibre user, and I need some help creating a custom "column built from other columns."

Column #1 is a custom "floating point number" column named AudPrice (lookup = #price).
Column #2 is the same and is named AmzPrice (lookup = #price2).

I want the new column (TotalPrice; #price3) to add these two columns together. And I need it to be able to handle it if Column #2 is empty. In other words:
If #1 = 1.99 & #2 = .99 then I want the new column to say 2.98
OR if #1 is 1.99 and #2 is empty, then I want it to say 1.99 rather than giving an error.

Can anyone give me some code I can cut & paste into the "Template" box.

Thanks
abqkjh is offline   Reply With Quote