RED X in output BEx

[Former Member]

Hi there,

can someone tell me why i get red X in my BEx analyser listing.

There is NO data for a month that gives the red x, so i would like to supress these empty columns BUT because of the red x nothing is suppred !!

Greetz,

Herman

[Former Member · Accepted solution]

N.,

in the Query properties i marked the supress zeros, but i don't see here some other things to suppress X

Herman

[former_member184494 · Accepted solution]

Hermann,

go to TCODE RSCUSTV4 and see what the X stands for - usually it is for divide by zero ... to not show the same in the formula for which this appears - change it by using NDIV0() where if there is a divide by zero - it will not show any results and hence you can suppress the zeroes..

Arun

hope it helps..

[Former Member]

Herman,

Is it a formula column for which it is showing red X? If so it might be due to formula collision. You can over come this by selecting which formula to run first from teh properties.

Also if you are using diff dimensions i.e diff currencies for amounts in formula better use NODIM() function.

[Former Member]

Hi

Have you checked settings in Bex query property...you can make them empty

Regards

N Ganesh