Set Analysis Query

[#1]

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

[#2]

anyone??

[Miguel_Angel_Baeyens · Accepted solution]

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica