TM1 Forum

Hello,

I discovered that any array formulas in the data area of a CAFE flex view will be automatically converted to a non-array one after the view is refreshed. Is there some trick to keep those array formulas ?

Thanks a lot

Build: 10.2.5220.51
Excel 2010

Hello, Try Options--> cognos analysis --> preserver user formulas. Thanks.

Not only the array formulas, but also the format determing the number of decimals can be erased by a refresh, I have to use ROUND() instead

rksharmatm1 wrote:Hello, Try Options--> cognos analysis --> preserver user formulas. Thanks.

Not working, thanks anyway

If ROUND() can help to define a decimal format from an Excel calculation within a flex view, how to define a percentage style