CSPro Users Forum

Dear Sir,

I created a lookup file which contains prices of goods at different geographical level in on file per record , is there a possibility to do first an EA level match and if item found at ea level the compare and take EA price , if not go to district and ......

The file look like ---> Region Zone District EA EA Price District Price zone price EA Price

Thank you,

Does this logic behave the way you want?

Thank you Aaron . I will try it, I toughs length of dictionary item should match during loadcase.

You're correct, the combined length of the variables needs to be equal to the length of the case id. Take a look at this: