Enable the Total value for columns in Reports Setting - Computation Data

Enable the Total value for columns in Reports Setting - Computation Data

To Add Total Values for columns in report setting -Computation Data

Purpose: We can add the columns in Computation Data so that we will check the total value in bottom of the column in reports
* The below process is the format for enabling the computation datas in reports. As an example we have prepared the same for "Billwise Itemwise Sales Details"

Step 1: Go to Reports --> Sales --> Sales --> Billwise Itemwise Sales Details


Step 2:Select a date by clicking Select Period. Select the Branch from the list. Multiple branch selection is also allowed. By default, it will take "All locations", and select apply button, by which data will be generated.


And data will be generated in the reports.


Step 3: Click on Settings --> Computation Data as like in below screenshot

Step 4: Search for the column name in search box and enable the checklist as like in below screenshot and Save the setting


* Now you can check the reports and you will able to find the total value at the bottom of the column in that particular report.


To Enable Average Value in report settings 

Purpose – When the Average option is selected, the columns enabled under Computing Data will be displayed. You can enable only the required columns to view their average values.

Step 1: Go to Reports --> Sales --> Sales --> Billwise Itemwise Sales Details


Step 2:Select a date by clicking Select Period. Select the Branch from the list. Multiple branch selection is also allowed. By default, it will take "All locations", and select apply button, by which data will be generated.


And data will be generated in the reports.


Step 3: Click on Settings --> Computation Data as like in below screenshot


Step 4: Enable the column name which required as like in below screenshot and Save the setting



 Now you can check the reports and you will able to find the Average value at the bottom of the column in that particular report.


    • Related Articles

    • Reports >> Settings

      In this document, we will learn the process of 1) Grouping the columns in report - To group the columns under one head column value for better ordering and dimensional view of the report. 2) Exporting report - To export the report in desired format ...

    • Setting Tax inclusive and Exclusive

      Intro on Tax inclusive and Exclusive It's easy to determine the difference between inclusive tax and exclusive tax. It all depends on whether the tax is added on top of the total retail price, or not. Inclusive tax - The taxes are already a part of ...

    • Clear data Process

      Data Clean request Purpose : To clear the master and transaction data from the pos and update the new menu setup. The Transaction and master data will be cleared from POS and old data will not be visible in POS. The clear data process can be done ...

    • Tender Type Value

      Introduction to Tender Type Value Tender Type Value includes only the Credit Tender Type. Under the credit mode, which is created in the Tender Type Master, specific tender values can be mapped accordingly. Example: If a Tender Type Master is created ...

    • Item Category Value

      Purpose The Item Category Value is an extension of the base item category, functioning like a subcategory. It allows for more precise classification of items, providing better organization and control over inventory and sales management. Benefits of ...