Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable called "Days of Supply" this will show me the number of days based on the qty on hand we have. My problem right now is that It is showing the total days of supply and I am wanting it to show me the days of supply based on each individual inventory item. Is there something I'm missing to make this happen?
I also am having the same issue with the monthly average. My monthly average is showing me the total monthly average of all products. What I am wanting to see is:
For each tran Period I have selected it will total up my Qty by Month column for that item and give me the monthly average based on that item and the tran periods that are selected.
.png "Former Employee"){kind=icon}
The variable was referencing another variable which was referencing another. So i used $() syntax in all the nested variable references to that its all dynamic.
The next issue is that this is a chart dimension, and you need to use AGGR() for a dynamic aggregation. AGGR() is best avoided for performance issues if you can so i would suggest implementing this as an expresison rather than dimension.
If you have to use dimension, you need to pass all the aggregation levels to aggr() . In your QVW that led me to this formula for the calculated dimension. I added a formatting mask to limit to 2 decimals because there are many once the breakdowns show up. Change as you wish
=num(aggr( $(DaysOfSupply),InventoryCD,Descr,QtyOnHand),'#,##0.00')
note for debug purposes i hid a lot of the calculated dimensions so just uncheck conditional on each one. I did not go through all dimensions and check for any corrections.
