Search results for query: *

I have a table which looks like this: Account# | Debit_Points | Bonus_points | Offer 123456789| 22 | 5 | MULTI10 234567890| 0 | 50 | MULTI20 987654100| 109 | 100 | MULTI30 I need to create a table that looks like...

Hi Klaz.. I was able to figure out the date field, but for the datetime field it comes in as this: 01OCT04:00:00:00 but I need to have it like this: 20041001:00:00:00 (4 digit year, 2 digit month, 2 digit day) Thanks!

Hi, I have a dataset w/ date fields and datetime fields and I need to it in a certain format in a text file (no dashes). I'm using the compress function but tt's giving me a syntax error and not sure how to fix it. Here is my code. Anyone tell me how to fix it? libname a ...; %let out_file =...

Hi, I am in need of some serious help... I have a simple formula that works perfectly fine: Total = New Purchases + Reinvestment - Redeption I have a Commission Adjustment amount that I need to add to the total. So the formula is now: Total = New Purchases + Reinvestment + Commission -...

Hello, How can I separate the totals for each Trsnsaction Type? Thanks.

Hello, I have data that contains Broker Name, Transaction Type and Commission. There are 3 Transaction types: NP, WD and RI. WD is actually 2 types combined as one: FR and PR. I have a formula that gives me count of each transaction type by Broker Name. But what I need now is a total of...

Hello, I am currently creating a presentation for my wedding with pictures of myself and my fiancee and would like to add different songs to play during different sections of the presentation. When I add a song (Through Insert -> Movies and Sounds) it only plays during the first screen and when...

Hello, I have a formula that is supposed to extract a certain Broker # based on a parameter date range. It's not working. Can you please tell me what is wrong with it? Thanks! IF ({Crystal Report LookUp\Transaction Status.CAD Broker#<String>} = "18051") THEN CDate({Crystal Report...

Hello, I have a report with a list of people grouped by division they belong to. 1.I have a formula that counts the # of deals for each person. Count ({Q1_Ins_Tbl.Life_Ins}, {Q1_Ins_Tbl.Name}) 2.Within the deal, a person could have sold an insurance sale. Each sale is identified by a...

Hello, I'm using the following formula to calculate a dollar figure for each person in a group: if {@Pene Rate} >= 57 then {@Total Life Insurance} * 25 else {@Total Life Insurance} * 0 How can I get the sum of the dollar figure for the entire group?

I have a formula that counts the number of X's. Another formula that counts the number of Y's. A subtotal that sums the # of X's and Y's. I have a Grand Total #. I'm trying to get the percentage of the subtotal from the Grand Total, but it's giving me the wrong number. Why? Thx.