Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to group my measures like :
1.Openning Stock On hand
2.Budget Recommended Order
3.Recommended Order
4.Inbound Orders
in one group like Supply Plan
and
5.Actual Receipt
6.Adherence to Plan (Factory)%
7.Sales Budget Unit
in other group name Sales Plan.
Note :
All my measures are calculative field got from different view . They all are expressions.
And Product Code,Product, Commercial Manager are Dimensions
I want to see my file like :
Product Code,Product, Commercial Manager , Group, Bucket Description sequence.
I am giving a snapshot of my report.
Need Help.
Thanks In Advance.
Hi ,
I have tried this in inline :
LOAD * INLINE [
Group,name
SupplyPlan,Opening Stock On Hand
SupplyPlan,Budget Recommended Order
SupplyPlan,Recommended Order
SupplyPlan,Inbound Orders
SupplyPlan,Actual Receipts
SupplyPlan,Adherence to plan(Factory)
SalesPlan,Sales Budget Units
SalesPlan,Sales Plan(Planner Forecast)
SalesPlan,Actual Sales
SalesPlan,Customer Orders
SalesPlan,Adherence to Plan(MAPE3)
SalesPlan,Adherence to Plan(ARITH1)
SalesPlan,Model Stock Units
Inventory,Days On Hand
Inventory,Projected Adjustment
Inventory,Closing Stock On Hand
Inventory,Safety Stock Units
Inventory,Opening Stock on Hand Horizon Inbound Orders
Inventory,Full Horizon Inbound Orders
Inventory,Closing Stock on Hand Horizon Inbound Orders
Inventory,RISK
Inventory,Blocked Stock
];
I am near to my report . but I got stuck in calculating a field :
Please see my expression :
if(name= 'Opening Stock On Hand', sum(opening_stock_unit),
if(name= 'Budget Recommended Order',sum(budget_recommended_order_quantity),
if(name= 'Recommended Order',sum(recommended_order),
if(name= 'Inbound Orders',sum(inbound_orders),
if(name= 'Actual Receipts', sum(purchase_receipts),
if(name= 'Adherence to plan(Factory)',(sum(purchase_receipts)/sum(inbound_orders)*100),
if(name= 'Sales Budget Units',sum(sales_budget_units),
if(name= 'Sales Plan(Planner Forecast)',sum(sales_plan),
if(name= 'Actual Sales', sum(sale_units),
if(name= 'Customer Orders',sum(customer_order),
if(name= 'Adherence to Plan(MAPE3)',(100-fabs(sum(error))/Sum([actual])*100),
if(name= 'Adherence to Plan(ARITH1)',(Sum([Actual Units])/Sum([Forecast Units])*100),
if(name= 'Model Stock Units', sum(model_stock_units),
if(name= 'Days On Hand',sum(days_on_hand),
if(name= 'Projected Adjustment',Sum(projected_adjustment_unit),
if(name= 'Closing Stock On Hand',sum([closing_stock_unit]),
if(name= 'Opening Stock on Hand Horizon Inbound Orders',Sum(OpeningStockOnHandHorizon),
if(name= 'Full Horizon Inbound Orders',Sum(FullHorizonInbounds),
if(name= 'Closing Stock on Hand Horizon Inbound Orders', Sum(ClosingStockOnHandHorizon),
if(name= 'RISK',RangeMin(0, $(vRisks)-$(vUnit)),Sum(qa_blocked_stock)))))))))))))))))))))
everything is working fine ecxcept ( the bolded expression)
if(name= 'RISK',RangeMin(0, $(vRisks)-$(vUnit))
as this two is expression contain variable that why I am unable to get the result.
can someone help how to calculate MAPE3 : max(0,100% - fabs(sum(error))/Sum([actual])*100) ??
and how to put RISK calculation ??
can someone help how to calculate MAPE3 : max(0,100% -fabs(sum(error))/Sum([actual])*100) ??
this is the solution if you want to group your expression.
Check your closing ) if they are right.
