cancel
Showing results for 
Search instead for 
Did you mean: 

RKF

Former Member
0 Kudos

HI expersts,

I have RKF and its displaying all the values out of some zeros also displaying .Can any one suggest me how to exclude these zero values in output .

Regards

Rk

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Please go to query poperties and set display Zero as Blank.

Also suppress row where all values equal to Zero

-Vikram.

Former Member
0 Kudos

Hi,

Thank you very much for your replies . here i need to peramanantly remcoved zeros like how we are excluding # . if i go your suggestions my condtion is not full fill .Here out of zero values i need to take minmum value . if i go poperties and set display Zero as Blank.the out put physically is not displaying but minmum value is internally taking zeros . do you any alternate suggestions.

Regards

Rk

Pravender
Active Contributor
0 Kudos

Not sure about your exact requirement.

If you want to exclude the zero values, then you can create a condition for the key figure and define it <> 0.

Answers (2)

Answers (2)

Former Member
0 Kudos

HI,

Open the query, go to properties, there go to tab 'Value Display'. In this tab you will find 'Display zero' drop-down box, there select " Zero as Space".

This will replace all zeroes as blank.

Hope this helps.

thanks,

rahul

Former Member
0 Kudos

Hi,

1) Goto Properties of Query

2) In Value diisplay Tab >> Select " Zero as Space" in Display Zeros. dropdown box.

Thanks,

Jitender.