isitpossibletodisplaykeyfigureas'N/A'inrHi,buddiesDoesanyoneknowhowtodisplay'N/A'inBWreportifthekeyfiguredatadoesn'texist?e.g.IhavedailysalesdatafromJan.1,2002toJan10,2002incube.WhenIrunreportagainstit,Isele

Question

is it possible to display key figure as 'N/A' in r
Hi,buddiesDoes anyone know how to display 'N/A' in BW report if the key figure data doesn't exist?e.g.I have daily sales data from Jan.1,2002 to Jan 10,2002 in cube.When I run report against it,I select from Jan 8 to Jan 12.Is it possible that the report displays sales data from Jan 8 to Jan 10,and displays 'N/A' for Jan 11 and Jan 12.

Answer 1

If for a specific customer or date there is no sales, then that date or customer is not displayed in the output of the query. This is my experience in 2.0B, for if you filter only on that customer, you are likely to get 'No applicable data found'. But there have been some instances where, example due to returns, the sales becomes 0 and this is displayed as 0. 查看原帖>>