Returns the “PRICE” dictionary result (with all its conversions) from record with ID “12001” from file “SALES”.
BASIC TOTAL.LINE.CALC subroutine is executed, which multiplies the B40 cell content with that of C40 cell.
Executes “GET.FINAL.PRODUCT.PRICE subroutine that obtains the product final prize with ID 100 bought in as many units as B20 cell indicates.
Extracts multivalue 1 from “LISTPRICE” dictionary from record with ID “1” from “ORDERS” file.
Get max value of multiple records
With our Add-ins for MV databases, the connection and following exploitation can be carried out in an easy way. Besides the power of Queries running as complex as wished, you can quickly access to concrete data through the available Excel functions use. It has never been so easy to customize documents or emit reports.
Although the access from Excel can be done in native way, sometimes is too complicated to configure the SQL access from Excel to obtain a few of simple values. With our Add-in besides the native usefulnesses, you have other tools that will allow you customize your documents or reports.
Buy securely through our payment gateway and enjoy everything we offer you. We do not keep any sensitive data.
We test our products conscientiously so that you enjoy a quality product
We are always available to solve your doubts, questions and suggestions about our products
Discover the best solution to explode your data in an easy and simple way