Number Type Field Calculations

#1

I want to add a custom Number Type field and name it “Final Purchase Price” or “Product Cost after expenses”.
Then I’ll have it show the result of doing the following:
mulitiply with currency exchange and
add the shipping,packing,logistic expenses.

Can it be done ?
Its not for reports. I want it displayed with:
“Checked” Show custom field as a column

#2

You cannot do exactly what you describe. What you can do is create a custom theme that will perform a limited range of calculations on custom and built-in fields. See https://www.manager.io/guides/17115 for an introduction to the capability. The Guide is not comprehensive, as implementation requires sophisticated coding that is generally beyond the scope of either the Guides or the forum.

None of this will show up as a column in tab listings.

1 Like
#3

Thank you for your answer. It seems the only way is with custom field, and batch update after doing the calculations in excel?