There is definitely something strange going on with this. If you go into the LOD Unique Orders calc and just change it non-materially by adding a space inside the bracket it works. Go back and take it out and it gives the wrong number again.
I only have 9.3 installed and cannot open your workbook, but I guess your problem is similar to the one in the following post.
My conclusion was that a lod within a IF or CASE statements inherits(includes) in the level of detail, the dimensions of the all the conditions of the IF statement.
YES!! Thank you so much. I added the additional Exclude statement to my calculation and all is working now. I really appreciation the direction