Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table and I am using this expression
SUm(Aggr(
If(sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)>
sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),
sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),
sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)),Prod_Variety_Number))
My Dimension is Prod_Variety_Number, but I am loosing rows when I am doing this expression.
Any idea what am I doing wrong?
No Idea.. But, Try to use this and share screen where values are getting wrong?
If(sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)>sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),
sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty))
Already tried this first
Can you consider as expresions like
1) sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)
2) sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders)
And show image?
May be this
Sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"}>} Aggr(
If(sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)>
sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),
sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),
sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)),Prod_Variety_Number))
Please se the attached . On top u see the results seperately and at the bottom I expect to see 1330390 cuz that is not greater then sum orders
Doesnt work, still missing rows
Would you be able to share a qvw sample?
Validation looks Okay? Can you highlight where you getting wrong?
Can we do a screen sharing or something?