Need help to avoid hardcoding SELECT
Need some guidance on how I can avoid hardcoding.
Let say I have a module A that applies to Country and Product (Coke and Pepsi) and line item as sales
I have another module B that applies to country and I want to create two line items Sales - Coke and Sales - Pepsi which I then want to compare variance.
This is the formula I am currently using
Sales - Coke = A.Sales[Select: Product.Coke]
Sales - Pepsi = A.Sales[Select: Product.Pepsi]
How can I avoid the hardcoding for SELECT? I tried creating a constant module and creating two lines item type Product. Using them in the SELECT like below gives me error
Sales - Coke - A.Sales[SELECT: Constants.Product1]
The name Constant.Product1 used in the SELECT clause is not recognized as a list member or version in the model