Search results for query: *

Here is my data: A1 A A2 B A3 C A4 D B1 1 B2 2 B3 3 B4 4 E1 A E2 C E3 E E4 B I need a formula that will: If cell E1 is within range A:A then cell F1 should result B# My results in F should be: F1 1 F2 3 F3 "blank" F4 2 Thanks Catherine

I need to find a way to edit a currency field with a formula to remove "," and decimal points and to have the result 10 digits long. For example, 12,866.90 would need to be 0001286690. I cannot simply do this with the "format field" option on the report as that does not actually chance the...

I have a field that is a string and the data reads like: 123A 56785A 12-5A The first part of it varies on how many characters that it has but it will always end in the letter "A" I want a formula that I can eliminate the A - I only want characters prior to A to display Thanks for all your...

I have a Crystal report that has a field type of STRING - it is linked and pulling data from an excel spreadsheet The data in this field varies, some of the results have numbers & letters (12M, 2T), some are just numbers (4, 5) This field is not displaying results that are just numbers (it is...

How do I underlay multiple sections on a Crystal Report? I have a report designed with GH1 GH2 - suppressed GF2a GF2b GF2c I want all four groups (GH1, GF2a, GF2b, GF2c) to be on the same line - I have all the sections above checked "Underlay Following Sections" It's lining up GH1 &...

I have a Two Year Customer Sales History Report. It is grouped by 1) Salesrep 2) Customer I have ranked the sales dollar for the most recent year in the report. I want to show the customer's rank from the previous year on this report. This is what I've done: 1. Create your customer sales...