Product sales to be multiplied by constant numbers

[Anonymous]

Dear all,

I have a daily sales table with products.

The product sales need to be multiplied with a constant number which is defined in a product master table.

The master product table is such that each product is given a unique number.

For eg : SKU 1 has a fixed number 2

So every time the sales for SKU 1 are shown we need to multiply its sales by 2.

How do i do this? Simple, multiplication does not work .

[JosefPrakljacic · Accepted solution]

Hello @Anonymous, 

1. Please make sure that your relationships are in place. (ProductMaster 1 : * Products)
2. Create a calculated column and use the Related Function -> Related(ColumnFrom-ProductMaster) to get the Sku Info and then write your IF/Switch Condition.

Please provide us with some sample data if you need more help.

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

[Anonymous]

Hi @JosefPrakljacic this is not working

since my sales table is at a lower level of product hierarchy than the product master table.

I have  multiple codes for the same product defined in my sales table

[Anonymous]

IT WORKED

THANKS....