Skip to main content
April 8, 2024
Solved

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

  • April 8, 2024
  • 2 replies
  • 0 views

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

 

Best answer by RehaanAbdulla

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

2 replies

April 9, 2024

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

RehaanAbdullaAuthorAnswer
April 10, 2024

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