Is it possible to add up numeric asset fields

in the k1000. For instance the cost of items

or any other asset field that has numbers.

Can I generate a report that adds up all the

fields and gives me a total ???

Thanks All.

0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



You cannot do math in reports when you create a report using the wizard: you need to use a SQL report.
What you can do to ease the creation of the SQL report is to create a sort of blueprint with the wizard and then modify the SQL of the report.

If you like to play a bit more interactively with the SQL and KACE you can enable in the Settings -> Security Settings the database access and use something like TOAD for MySQL or MySQL Workbench (free products) to better model your query.

This video explains how to connect to the K1000 database:

kind regards,
Marco - StockTrader
Answered 11/10/2015 by: StockTrader
Red Belt

  • Thanks for the quick reply Stocktrader...
    Cheers mate.
Please log in to comment