Hello,
I was wondering has anyone got a solution to replacing /0 (divide by zero error) in a cube with 0. I have some calculations that are completed with a "Calculate Measure" in transformer and in cases gives me some results like /0. It is not possible to complete these calculations in the reports (IQD) as the values come from different reports. I tried using a macro but my only success was to make the values that occur with /0 turn to blank. This is not ideal. I would prefer /0 turned to 0. Anyone got this problem as well or any solutions to it? Any help would be appreciated
I was wondering has anyone got a solution to replacing /0 (divide by zero error) in a cube with 0. I have some calculations that are completed with a "Calculate Measure" in transformer and in cases gives me some results like /0. It is not possible to complete these calculations in the reports (IQD) as the values come from different reports. I tried using a macro but my only success was to make the values that occur with /0 turn to blank. This is not ideal. I would prefer /0 turned to 0. Anyone got this problem as well or any solutions to it? Any help would be appreciated