TM1 Forum

Posted: **Wed Feb 25, 2015 9:08 pm**

I have a calculated columns in Tm1 cube.
Columns is YTD Growth and this has a calculation like
IF(['YTD Change'] <> 0,(['YTD Change']/['Prior YTD Grouped']),0); in tm1 rules.

So what happens when the value of 'Prior YTD Grouped' becomes zero , divide by zero will happen and tm1 is smart enough it to replace it with "N/A"

This when Exported to Excel replaces "N/A" with the number 65535.

Is there anything we can do to retain the N/A value on the excel when exported.

Thanks,
Manu

Posted: **Wed Feb 25, 2015 9:14 pm**

Do you actually want it to show N/A in tm1?
If not just swap the divisor sign from / to \.

If you do want the N/A's in TM1 then looks like your exports will be an issue:
http://www-01.ibm.com/support/docview.w ... wg1PM85526

TM1 Forum

Export to Excel displays 65535 for N/A values

Export to Excel displays 65535 for N/A values

Re: Export to Excel displays 65535 for N/A values