We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Remove the zero values from the data output in flexmonster where data is coming from cube.

Answered
Nagaraj Chatiri asked on November 18, 2019

Hello Team, 
How to hide zero's in the attached screenshot, highlighted in black rectangular box. The data is coming from the cube. Please advise of the steps. 
 
Thanks
Nagaraj

Attachments:
hidezerorows.PNG

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 20, 2019

Hello, Nagaraj,
 
Thank you for your question.
 
If you want to hide cells containing 0 values altogether, we would like to report that such a feature is not implemented for SSAS data sources in the current version of Flexmonster.
 
If you desire only to hide the value but leave the cell displayed, we recommend using customizeCellFunction.
Change the text property of cell in the desired way.
The function should look like the following one for your case:

function customizeCellFunction(cell, data) {
if (data.value == 0) cell.text = "";
}

Learn more about customizeCellFunction by the link: https://www.flexmonster.com/api/customizecell/.

We hope it helps.

Regards,
Illia

Please login or Register to Submit Answer