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
Hi all, I have done the Init Load into an InfoCube 0Pur_c01. The Monitoring status is Green. I checked the Qm status which is green. There is data in the PSA. However, I am unable to view data in the InfoCube. Also when I execute the report I am rece [More]
Hello all, I have a 3rd gen ipad and a 3rd gen aptv. I have had them both for about 2 months and have enjoyed streaming the nbc, abc, safari and netflix apps to the aptv from the ipad using airplay(not mirror mode). Yesterday i was gettingd ready to [More]
I have a Mobile.Me account, and have been using iSyne to sync my address book for several of my Macs for quite a long time. Suddenly, this morning, iSyne said syncing will delete all my contacts in one of my computers. I foolishly click OK, and it de [More]
So, the other day I was browsing the web via firefox, and if I pressed enter or go, It wouldn't go to the website. No errors, it just simply wouldn't respond. So I reinstalled firefox, and problem solved! ...The only problem NOW is that I can't open [More]
I want to create a set up program that could install all the files and create a shortcut to that file on the desktop....plz tell me how to do it irrespective of the platform usedI need to do the same thing as you did. Did you get your problem resolve [More]
So, I was watching a movie in QuickTime yesterday and all of the sudden it froze and the screen was not really active at all. No key combinations worked so I held the power button and shut it down. I turned it back on and got the folder icon with the [More]
One of our publications is using InDesign and InCopy for producing the magazine. We're currently testing adding VersionCue CS 3 to the mix, but there's one problem that's preventing us from implementing that software. The magazine currently uses colo [More]
Hi everybody, I am relatively new to this forum. I have been using RH X5.02 now for a few months. |'m quite pleased with it until now and find all postings here very useful. So I was content until last monday when I returned from a holiday of 10 days [More]
i am trying to install flash player on my MS surface rt but it won't let me unless i use wondows store. flash player is not available in the windows store only adobe reader. how can i install flash player?Hello, If you have Matlab installed it could [More]
Firefox opens the Comcast e-mail window and inbox is visible,. but you can't open the e-mails. Their Customer service told me I have to use Explorer, which does indeed work. Also, Explorer scales the page automatically to full size. I really don't wa [More]