02-02-2023 02:34 PM - last edited on 05-24-2023 12:20 PM by JackLacava
Hello,
I'm trying to format No Data cells as dashes on some cube views. Currently, the number format for the cube view is as follows: [#,##0;(#,##0);-]. This is formats zeros as dashes, but not No Data cells. Is anyone aware of a special formatting to change No Data cells?
02-02-2023 06:18 PM
I have also been looking for this issues but it is not possible as per my knowlegde.
02-03-2023 05:43 AM
Hi, not that I am aware of (at least not for Cube Views). If needed, you can set up a dynamic member in a UD for reporting with the following formula (in this example, the member is being set up in UD8):
02-03-2023 10:20 AM
Oh thank you I think that'll work for what I need! Also good to know that is a enhancement coming in the future.