Skip to main content
Apr 8, 2024 2:29 PM UTC
Solved

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

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

RehaanAbdulla_0-1712586494781.png

 

RehaanAbdulla_1-1712586552707.png

 

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

Regards

Rehaan

 

Apr 10, 2024 9:43 AM UTC

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

2 replies

Newcomer
Apr 9, 2024 7:30 PM UTC

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

RehaanAbdullaAuthorAnswer
Apr 10, 2024 9:43 AM UTC

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