My question is whether or not you can have two different aggregated columns from the same fact table in an RPD data model.
- I have one fact table and one dimension table.
- The fact table has two columns that need to be aggregated: Amount, and Projection.
Both columns are setup in the RPD like this: 
But, Projection column only produces zeros.
Is it possible to have two different measures in a fact table? Do I need to separate them into different tables? I don't know why this is happening unless it's just (probably) bad data modeling.
I am new to this modeling thing, and I could really use some guidance.