Overview

Pricefx offers calculation grids as a powerful tool within its comprehensive pricing software solution. Calculation grids provide you with a flexible and efficient way to perform complex pricing calculations, enabling your business to optimize pricing strategies and make informed decisions.

Calculation Grids are intended for working with a large amount of row-like data (items) that are not tied to SKUs and therefore cannot be processed in Price Lists, Live Price Grids or Quotes. With Calculation Grids you are able to modify, execute and store data like supplier costs, promotions, etc.

Key facts about Calculation Grids:

☑️ A configuration wizard that helps you with the setup.

☑️ Table keys can come from data, a calculation logic or can be configured manually.

☑️ Table rows (line items) are generated by a dedicated calculation logic.

Additionally, Pricefx's calculation grids integrate seamlessly with other capabilities within the system, such as price optimization, and price analytics. This integration enhances the overall pricing capabilities and empowers businesses to make data-driven decisions that drive profitability and competitive advantage.

By leveraging these powerful tools, companies can gain deeper insights into their pricing strategies, optimize profitability, and stay ahead in today's dynamic and competitive market landscape.

Explore Calculation Grids (CG)

Calculation Grids enable you to tailor your pricing calculations to meet specific requirements and objectives. You can create and manage multiple grids for different products, markets, or pricing scenarios, ensuring that pricing strategies can be adapted to various business contexts.

To access the CG go to Price Setting ➡️ Calculation Grids. Here you can view and modify the calculation grids that already exist or you can create new ones.

When you enter the Calculation Grids, the system displays all the existing grids. You can use the calculate button in the lower black ribbon, to calculate a new grid or recalculate an existing one. Simply click the checkbox and calculate to run the calculation. It is recommended to run the calculation if changes have been made.

You can also delete a calculation grid. To do this, click the checkbox, then delete.

In this screen you can also add a new calculation grid by clicking the New Calculation Grid button in the upper right corner.

Create a Calculation Grid

To do this, as you have seen before, go to Price Setting ➡️ Calculation Grids ➡️ New Calculation Grid.In the Define Calculation Grid step you will have to enter a label. You can also choose to set a Target Date (fixed date) or a Relative Target Date (relative to the current date, e.g., setting -5 means the system will consider Company Parameters which are valid at current date (= date of calculation of LPG) - 5 days). This target date will be used in the price calculation.

You can now move on to the Select Keys tab. You will need to select a Key Type. You can choose between 3 preset options.

☑️ Data Driven – Select up to six keys. The result data table will be automatically generated based on the number of keys and the selected restricted values.

☑️ Logic Driven – Keys are generated by a calculation logic. Select a calculation logic (of the Calculation Grid Keys nature) and the element containing the keys.

☑️ Manual – Select up to six keys. An empty result data table will be created leaving it up to the user to populate it manually.

You can now move on to the Set Parameters tab to select a calculation logic (of the Calculation Grid nature) that will calculate the grid. In the Output Elements step you will see the results you wanted to have as columns in this Calculation Grid based on the calculation logic elements you selected. You can select up to 100 elements.

When you have completed all the tabs in the New Calculation Grid step, you can click Finish.

Running the calculation

When you have a new Calculation Grid ready, select it in the list and click the Calculate button.

After the calculation has been performed, the status of the Calculation Grid will change from Draft to Pending, then Processing and finally Ready.

You will need to refresh the list by clicking the Refresh icon in order to see the status change. Upon completion, you can submit the grid for approval. You will get a notification message informing you that the grid has been submitted.

If needed, you can cancel the running calculation of a Calculation Grid (when it is in the Pending or Processing state). Click the Status and cancel the calculation in the Job/Task Tracking dialog.