michaelrekas123
09-05-03, 01:45
| I am playing with OLAP cubes and connot work out the following problem: The sales database has a field for {TransactionType} with values of "Sales" or "Returns". However the {TransactionAmount} field stores the amount as positive regardless of whether the transaction is a sale (positive) or a return (negative). Is there a way to overcome this? Thanks Michael |