Need Brain Salad Surgery on a particular expression

[tbolan]

Acutally I'm hardly over the hump in figuring out how to write expressions. I purchased a tutorial that didn't go into any detail on it.

I'm looking to take my on hand inventory quantity and back out all receipts, returns, issues and adjustments over a given time then multiply what's left by a value. Like this,

[Materials].[R5STOCK].[STO_QTY] - [Materials].[R5TRANSLINES].[TRL_QTY] * [Materials].[R5STOCK].[STO_AVGPRICE]

This just doesn't get it. I could whip it out in a flash with SQL, but I can't seem to figure out how to make the fat lady sing with my new play toy.

Any help would be appreciated.

[Merri]

Well, for a start, you could try using some brackets in there to force the order of calculation.

You also need to be careful about mixing data types (although this shouldn't be a problem in your case), as you can get some unexpected results.

And finally, if you come up with some complicated expression which just doesn't work, try creating data items with the inner calculations, and then use those data items in the outer calculations.

Hope this helps.