Dynamic calculated field (WOI)

[jacek2703]

Hi guys,

how to insert a dynamic calculated field (WOI - week of inventory) into a table, calculated as the quotient of the inventory from a given week and the average sales from the last 8 weeks?

Dimension - [Fiscal Week] (Table 'Calendar')

Measures - [# Stock] (Table 'INV'), [# Sales Out] (Table 'SO')

Sending over excel example.

Thank you in advance!

J.

[NageshSG]

Hi @jacek2703 

Here is one workaround (qvw file attached) to handle this in the script side by creating a bridge link table to Data table. The user can change the WOI range in the input box but requires a reload.

To make this work across fiscal years, you need to create an autonumber key of the FiscalWeek so that dynamically WOI Range bucket can be handled easily.

Hope this works and you can enhance further to meet more complex scenarios.

Regards.