Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is this Correct expression ?
I just need to sum of Order qty based on Item Category = UsedCars & Division =50 & Partner_Func =ZS.
How to acheive this. I tried the below expression its not working.
sum({<[Item Category]={UsedCars}, [Division] ={50}, [Partner_Func] ={ZS}>} [Order qty])
Try this:
sum({<[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}>} [Order qty])
Try this:
sum({<[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}>} [Order qty])
Try this:
sum({<[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}>} [Order qty])
HTH
Sushil
Try using ' for string values
sum({<[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}>} [Order qty])
hai can any one explain what is setanalysis?