Sitemap

Amicuk Programming Answers

Help with Count function

-0001-11-30   Views:0

Advertisement

Post Author: RJPiekos CA Forum: Desktop Intelligence Reporting I am trying to use the count function to count the number of unique PO numbers in a column. The program returns a value of "1" even when there are no PO's to be counted. Is there som

Post Author: RJPiekos
CA Forum: Desktop Intelligence Reporting
I am trying to use the count function to count the number of unique PO numbers in a column. The program returns a value of "1" even when there are no PO's to be counted. Is there some system setting that i am missing.
The universe that i am using is a free-hand SQL query to to an MS Access .mdb file. (if that makes a difference)
Desktop IntelligenceBO 11.5
Rick

The replay answer
Advertisement
Post Author: RJPiekos
CA Forum: Desktop Intelligence Reporting
Found my problem - 'empty' values in the PO column were not NULL.

Go to See the other 2 answers

Counter function value to multiple elements as same value in different node

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

I need your help! I have a counter function and value of that needs to be passed to two elements of Node A and Sub Node B.. Ex: Mapping Map Counter function to NodeA.Element1 and also to NodeB(subnode).Element2 Expected Result: NodA.Element1 = 1 Node[More]

Count() function throws error in EQL query for metric

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

Hi I am trying to use count function in EQL query for Metric Bar to show the number of occurrences of a record. When the record type doesn't exist i expect the function to return count as 0. Instead the function throws a runtime exception and the who[More]

OBIEE: Incorrect SQL - with count function uses ORDER BY instead GROUP BY

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

I made a basic report that is a client count; I want to know how many clients the company have. But, when I run this report, OBIEE generates a ORDER BY sentence, instead a GROUP BY. Remember that I'm using count function, that is a agregation. The SQ[More]

Sql count function in order by clause

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

Post Author: krypton CA Forum: Data Connectivity and SQL Hi Guys Can i ask a quick question. I am trying to retrieve data remotely from a SQL Server via crystal reports. Within the Database Expert I have entered a SQL query to retrive the number of ([More]

Distinct Count Function-how to use properly

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

Hello, I am new to using forums & have only been using Crystal since May of 2009, so i hope i do this correctly & provide the appropriate information.  i've looked for this answer in what's been posted but cannot find it.  Some things i've read I[More]

Count-Function in Message Mapping

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

Hey, trying to map following structures: message -m1 --m11 -m2 --m22 -m3 --m33 to message -m1 --m11 -m2 --m22 -m3 --m33 -f1 --countItems The nodes m1,m2 and m3 can appear 1..unbounded. In target structure I would like to have the numbers of all nodes[More]

Count function in Administration Tool

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

Hello, I am using Oracle BIEE 10.1.3.3 and tried using the count function in the repository so that the users have the field ready in Answers but the consistency checker returned an error stating: [38083] The Attribute 'No of Movements' defines a mea[More]

How to include the COUNT Function in business rule

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

Hi all,      I am working in oracle data quality in ODI.      This is regarding the business rule in Data quality.      I need to count the number of records when my status_type="A".      But when i include the COUNT function in business rule.  [More]

Why is the Tick Count function slow when used with a .dll but fine with normal lab view code?

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

when using the Tick Count millisecond timer with a .dll I've written in C, I'm getting some odd timing issues. When I code the function I want (I'll explain it below in case it helps) in LV and run it as a subVI, feeding it the Tick count as an argum[More]

Count the no.of rows without using count function

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

Hi, How to count the no.of rows without using the count function? Thanks,they won't be 100% accurate. You're correct, Bluefrog, but the same goes for doing a count(*) (depending on the size of the table, ofcourse): the table being queried might be un[More]

Error: DAQ-STC Counter functions missing from library

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

Using LabView 6.1, NI-DAQ 6.6.1 for MacOS on a laptop. DAQ Hardware: DAQCard 16E-4. When trying to use the advanced counter functions (for DAQ-STC type counters), LabVIEW generates an error saying that it can't find the function in the library. The c[More]

Hot
my apple id is not working in itunes. why?LeesaHeeley wrote: When I go to settings/iTunes App Store my Apple ID is not there. When I enter my ID and password it does not save or link to account. When fist setting up your new iphone you will be asked [More]
Hello, currently we are testing the jasper report engine. We are already able to open such a report from forms by a forms personalization. Now we want to run a concurrent report where the output should be a link to a jasper report. For example: I sta [More]
As my boot drive I have a new 1TB LaCie Thunderbolt SSD Disk. It's connected to a 27" 2.7 GHz Intel i5 iMac (mid 2011). I'm running OS X 10.8.2. Nothing else is connected on Thunderbolt. Everything runs fine and very fast, with the one exception of n [More]
i am looking for best practice on installing quicktime on win8.1 machines.  I only found discussion of installing in compatability mode.  Is that the best practice?it appears you posted an identical message in two threads.  i've responded in the othe [More]
Hello, I have a late 2013 Macbook Pro 15" with Retina display running bootcamp with Windows 7. I have connected the Macbook to an external HP w2448hc display using HDMI interface. When booting to OS X 10.9.4, the resolution of the external display is [More]
A client wants me to work on a text which is both english and arabic. I heard this is only possible with the arabic version of indesign? If I place the text in my present version, it comes out unreadable (arabic letters/words -but not connected and j [More]
While I was trying out the voice over option on my phone I somehow put it in a mode to where the screen stays black and it will only talk to me.  How do I get it back to normal?"If VoiceOver is on and the screen is black, but you can still use the de [More]
Hi all, On click of one button on main screen, i need pop up screen where i can edit this prepopulate text. Assistant Manager (CSM) request/removal Organisation reference         : 50158579 Add or Remove (A/R)           : Employee Full Name           [More]
I created site from Community Site Template and  activated publishing features. On the Welcome Page(publishing page) there is Discussion XSLTListViewWebpart - OOB webpart. In this case from Settings menu if I click 'Edit Page' nothing happens. I have [More]
     Today is the first day my trackpad won't swipe or scroll.  The cursor will move and I can click, but it won't perform any other options.  I have changed the batteries, shutdown the computer, when I look at preferences and trackpad, it says no tr [More]