Handling of converting cells to XFGetCell for column with member filter GetDataCell

[RehaanAbdulla]

Hi 

I would like to know if there is any settings or how would you deal with a cube view which has a member filter and in there a calculation for example F#None:UD4#AA5EX32011:Name(Cents):GetDataCell((Divide(CVC(Col1), CVC(Col3))*100). The user then exports the cube view to excel and converts each cell to an XFGetCells. See Screenshot 1. Once this is done the columns with the above formula return errors due to the calculation in that members. See Screenshot 2

Any advice or settings or best practice on how to deal with this?

Regards

Rehaan

[Jaymin]

Hi Rehaan, You can write XFGetCell formula to perform the Math vs using Quickview Getcell math. 

[RehaanAbdulla · Accepted solution]

There doesnt seem to be a way to handle it and it has been logged with the developers