Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please Suggest how to write this query in Set Analysis.
"
SET TempSum=0
Set CountRow=0
while(CountRow<162522)
{
If(NoOfPallets<>0)
TempSum= TempSum+Pallet
CountRow++;
}
"
Thanks,
Sandeepa
Hi,
As I asked you in a following post, where do you want to use that expression? If it's in an expression, you simply cannot do it. You cannot use loops in an expression. If CountRow is a dimension, then the expression should look like
Sum({< CountRow = {'<162522'}, NoOfPallets = {0} >} Pallet)
But please specify your requirements, actual input and expected output in your load script.
Hope that helps.
BI Consultant
anyone??
Hi,
As I asked you in a following post, where do you want to use that expression? If it's in an expression, you simply cannot do it. You cannot use loops in an expression. If CountRow is a dimension, then the expression should look like
Sum({< CountRow = {'<162522'}, NoOfPallets = {0} >} Pallet)
But please specify your requirements, actual input and expected output in your load script.
Hope that helps.
BI Consultant