You can use an expression to calculate based on a value of a variable. The variable will be what you alter based on what's coming in.

Because I don't know anything about your specific business model, rules, file formats, etc, I can't give you more details. Do some research on expressions and variables, and check some of the blogs here on the forums (http://www.sqlservercentral.com/blogs/[/url]) to see if anyone has done something close to what you have in mind. Then adapt and experiment.

If that doesn't work, you may have to hire a consultant. Pragmatic Works (based in Jacksonville, FL but willing to travel) includes a stable of some fantastically talented BI people. If they can't accomplish a task like this, I doubt anyone can.