I am trying to calculate the nett sales from the gross sales from my fact table.
I'm planning to use the variable input Custom Object to accept a value and store it in a Variable called 'myVar'. But how do I make this value affect my total sales?
My Nett Sales is (Gross Sales)-(myVar)%
Kindly help me with this
Solved! Go to Solution.
Hey @sunny_talwar !!
I've attached a qvf below.
It contains only one sheet, where the first KPI is the total gross sales and the Input Variable has the value 5. So, please help me display [Total Gross Sales] - 5% in the second KPI. The test data used for the .qvf is as in the screenshot attached.
@sunny_talwar would really appreciate your help on this.
Further to my initial query, I have split my sales to 2 entities. Now, I'm assigning different Credit for both entities, and need the % to be applied based on the entity names. Also I want that amount to be summed and arrive at the total Nett sales. I'm attaching a sample .qvf below, and also a screenshot of the sample data.
Thanks in advance, would really appreciate your help on this.