Amicuk Programming Answers

Help with Count function

-0001-11-30   Views:0


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

The replay answer
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 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]

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]