If you use field names in a calculation, DynamiCube will display zeros in every cell of the calculated column. Here is the best way to approach this situation:

When adding a calculated field in DynamiCube 3.0, you need to reference the VarName of the field(s) with which you wish to perform the calculation. You are allowed to set a field’s VarName to its Name but it is important to note that DynamiCube will use the VarName and not the field name.

For a demonstration of this technique please refer to the attached sample.

If you have any questions regarding DynamiCube 3 please feel free to submit a support request.