Sitemap

Amicuk Programming Answers

BEx report : To see 0 values instead of Blank

2015-10-11   Views:5

Advertisement

Hi all, We are using a formula in BI Report: Formula = Given_amt %A tot_amt Case1: if Given_amt is 0  and tot_amt is "not 0" then it should show 0.00% not BLANK. Case2: If there are no values for Given_amt and tot_amt it should show as a BLANK n

Hi all,
We are using a formula in BI Report:
Formula = Given_amt %A tot_amt
Case1:
if Given_amt is 0  and tot_amt is "not 0" then it should show 0.00% not BLANK.
Case2:
If there are no values for Given_amt and tot_amt it should show as a BLANK not 0.
Please advise.
Thanks in advance.
Sri

The replay answer
Advertisement
Hi Sri,
I need your help as I am in almost similar need as you were in...
We are using a formula in BI Report:
Formula = Given_amt %A tot_amt
if Given_amt OR tot_amt is "Zero" then it should show 0.00% not BLANK. How can I handle this...Please asist.
Thanks,
-Su

Go to See the other 6 answers

BEx report : To see 0 values instead of Blank

Category:DefaultRelease time:2015-10-11Views:130

Hi all, We are using a formula in BI Report: Formula = Given_amt %A tot_amt Case1: if Given_amt is 0  and tot_amt is "not 0" then it should show 0.00% not BLANK. Case2: If there are no values for Given_amt and tot_amt it should show as a BLANK n[More]

BEx Report : Selection Not Equal to Characteristics value 'blank' & more

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts, I 'm working on a report where I require one of the selection criteria for a key figure to be displayed when the characteristics 'rejection code' is not empty. So the selection would be like keyfigure: ZAMOUNT, when XREJ_CODE Not Equal to[More]

Concatenation of Data from 4 infoobjects into a single cell in Bex Report

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have loaded ODS with the description data. The source system for loading the ODS is the flat file. The ODS data should be a replica of the flat file. In the flat file, there is a description field corresponding to a particular ID. This Descript[More]

RFC connection Error While run BEx Report

Category:DefaultRelease time:2015-10-11Views:130

Hi All I got BI 7.0 and create new user with roles only access: TR: RRMX to see only BEx Reporting... I create basically new customize role and put only one transcation code RRMX and assigned to user... When goto BEx designer I got that error rfc err[More]

Header and Footer in a BEx report

Category:DefaultRelease time:2015-10-11Views:130

Hi Everyone, I have a requirement where I need to provide a space for the user to sign-off with their name and signature at the bottom of the print-out of a BEx report. For this purpose I need to provide a space at the bottom of the report where the[More]

Header and Footer  in BEX reporting

Category:DefaultRelease time:2015-10-11Views:130

Hai friends,      could you plz tell me how to add Header and Footer in  Bex report.. that means.. i want  some my company name and  address should print on the  top of the report.. and also.. in the Footer.  i want to display the Number of records a[More]

Shortened Fiscal Year and its impact on BI back end and Bex reports

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Our client is making some changes to the fiscal year period. Becuase of some business requirements, we will have to shortened the fiscal year. Can you please suggest - what are the watch points when we do this?                                [More]

Short Dump when the Bex-Report scheduled for Broadcast

Category:DefaultRelease time:2015-10-11Views:130

Hi Guru's I am getting the short dump when I am scheduling the Bex-Report for Broadcasting. Need your help to reslove this issue. Thanks Navin Note The following error text was processed in the system BDV : The current application triggered a termina[More]

Creating Chart in BeX Report

Category:DefaultRelease time:2015-10-11Views:130

I have few questions regarding creating Chart in BW Report. One thing I need to make it clear it's a simple BeX Report not a WAD report. (1) How should I create a chart in the Report?? Should I have to create it in the Excel Sheet once I run the repo[More]

BEx Report Performance with selection-screen input

Category:DefaultRelease time:2015-10-11Views:130

Hello Gurus, My Bex report is working fine when the report had run with out PLANT filter in the selection-screen but when report had run with plant in the selection-screen , report running for forever. Please let me know what I need to do improve the[More]

Bex Report Performance

Category:DefaultRelease time:2015-10-11Views:130

Dear Friends, I would like to know is the complex authorizations can also cause the Bex report performance. One of my scenerio is like there are two users A & B A is having relevant authorizations for reporting, Drill down etc which are required. B i[More]

Hot
Appreciate advice for eliminating this problem: Needle not moving when I record voice memos on iphone 4S. No sound in playback. Was working great until last week.Try restarting your iPhone by holding down the on/off and the home buttons at the same t [More]
When I bought my iPad 2 it was set up for wifi, but not for the same kind of wireless iteret connection I get with my cell phone? Now I want to add that, but when I called the phone company, they said my iPad 2 didn't have an "IMEI" number. Can [More]
Calendar sync via cable doesn't work now I've updated to Maverick and ios7.I am sorry you are having this trouble.  Here is an article on troubleshooting calendar syncing with iCloud.  See if the suggestions there are of help. http://support.apple.co [More]
I'm having two strange scenarios with the newest version of the Adobe Content Viewer and multi-state objects.  Both situations below were in v27 folios, and they worked perfectly fine on the Desktop Viewer, but when loaded onto an iPad and viewed thr [More]
Presently I have my 5.1 HDMI receiver hooked up to my AppleTV with wired speakers in my den. I also have another old receiver that also runs my AppleTV (analog) with speakers in my sunroom which are also wired. I am able to play my AppleTV music to b [More]
Hi all, While loading AS2 certificate of the Trading Partner in our system it is asking for the password to unloack the certificates but when i contacted the Trading Partner they have not set any password for the certificates . Can any one help what [More]
I am trying to match a particular color of blue in Word. I set the CYMK percentages using the either the sliders or %age boxes in Word, hit OK and then when I open the color setting box, the numbers have changed. Anyone got an idea of what I'm doing [More]
Hello Gurus, While I am debugging a report, is it possible to view the window that is building or the alv that is showing step by step according I am debugging the report? Thanks for your help.Hello Enrique, Yes, you can see what is in the internal t [More]
After the intro video I would like my book to open with the first page full screen, not with the contents. Is this possible? ThanksI have noticed that most of the books I've bought on the ibook store start on the first page rather than the contents, [More]
Hello, I'm trying to import data van 10XE version to new 11XE version over db_link. When using the method I run into following error: ORA-04052: error occurred when looking up remote object [email protected]<<db_link_name>> This seems to be a [More]