04-08-2024 10:29 AM
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
Solved! Go to Solution.
04-10-2024 05:43 AM
There doesnt seem to be a way to handle it and it has been logged with the developers
04-09-2024 03:30 PM
Hi Rehaan, You can write XFGetCell formula to perform the Math vs using Quickview Getcell math.
04-10-2024 05:43 AM
There doesnt seem to be a way to handle it and it has been logged with the developers