Hello erveryone!
For those who know it, I'm using Hyperion to retrieve sales data from a database.
Everything works fine exepted that hyperion fills < '0 > instead of < 0 > when the data is not available (most of the time it means 0).
The problem is the following, I use formulas that test if two rows are equal to zero by using the OR operator. Unfortunately, the < ' > in front of the zero leads to miss interpretation of the condition and the cell is not "seen" as beeing 0 (and therefore, condition always returns false).
I figured out a workaround by adding Cell="'0" to the OR statement. However, this increase the length of my formula and I'd like to find another solution if it exists.
Thank you for your help,
Antoine Praet
For those who know it, I'm using Hyperion to retrieve sales data from a database.
Everything works fine exepted that hyperion fills < '0 > instead of < 0 > when the data is not available (most of the time it means 0).
The problem is the following, I use formulas that test if two rows are equal to zero by using the OR operator. Unfortunately, the < ' > in front of the zero leads to miss interpretation of the condition and the cell is not "seen" as beeing 0 (and therefore, condition always returns false).
I figured out a workaround by adding Cell="'0" to the OR statement. However, this increase the length of my formula and I'd like to find another solution if it exists.
Thank you for your help,
Antoine Praet
