I have voucher numbers and dollar amounts that are duplicating - in some instances, not all.
How do I write a formula that would say:
look at the voucher number and the dollar amount, if they are repeated, then delete/omit from grand totals for each field (Voucher, Dollar Amount).
Thanks in...
Sorry, but I entered as you suggested and returned no results. I know there are records, as I've seen a few.
Selection Expert reads like this:
{Job History.Ship Via} = "W" and
{Job History.UserDef01} like "WALKUP/*/LORAINE *"
If I enter only [COLOR=red]{Job History.Ship Via} = "W" and
{Job...
I have a Definition field that I only want certain records for:
WALKUP/12345/LORIANE X1234
The 12345 number will vary, but rest of information will be the same.
Would I use a 'like'? Not sure how I would write it -
{Job History.Ship Via} = "W" and
{Job History.UserDef01} like...
I have a Description file that I only want certain records for:
WALKUP/12345/LORIANE X1234
The 12345 number will vary, but rest of information will be the same.
Would I use a 'like'? Not sure how I would write it -
{Job History.Ship Via} = "W" and
{Job History.UserDef01} like...
When I run my report in Crystal everything is fine. I end up with 83,188 records and 1,342 pages of data. I name the file and save it in Crystal. I click on the Export button. Select Excel 5.0 and Application. Report runs, but when I go into the Excel Temp file to look at the data, all the...
Below is the formula I am using. When I 'test', I (being both UserName and one of the 'cc') the message gets sent to both 'cc' people, but not the UserName. Can anyone tell me what the problem may be? Thanks in advance.
@MailSend(SendTo;@UserName:"John Doe": "Jane Doe"...
I may have confused you. I created a form that looks like an excel spreadsheet but within a table in Notes. Also, I do not know Lotus Script, so I do need to use formula's. This will not be used on the Web.
This is going to be a bit lengthy, but here goes. I have a an excel spreadsht that I am re-creating in Domino. It has a single field above the 'table' that asks the customer how many items they will be requesting, and the customer then specifies a number (1 thru 10).
The table has 6 columns and...
I have created a form that looks just like an Excel spreadsheet. The form has 5 rows and 6 columns. Our customer will complete 1 to 5 rows & and the first & sixth cell of each row, depending on their request. If the first cell (in each row) is complete, then the sixth cell (of that same row)...
is it possible for me to link my db form fields (only a few) with someone else's db - same form fields. And when they create a form, my db form is automatically created and populated with their information, and then I get a notification telling me this form has been created?
Thanks in advance...
This is what I have for a formula for @CritMet, which returns either true or false:
Sum ({Job Detail (History).Cost Center}, {Job Detail (History).JobNo})/Sum
({@task test}, {Job Detail (History).JobNo})=13
How do I specify that I only want to see the true?
Thanks.
The file is too large to send - I am working with 89,000 records out of 1,200,000, and I'm sure you don't want it either.
Here is an example of what I have showing in the group footer (details are hidden):
JobNum CostCenter(summed) task test(13=1,else 0, summed)
107414 247...
Okay, I'm back to working on this again - and I think I have it narrowed down.
As you suggested I subtotaled all the CostCenters and counted all the results of the 'test' (CostCenter 13 = 1 all others = zero). Then the subtotal of the CostCenters divided by the subtotal of the 'test' total =...
dgillz -
Still does not work correctly. The two job numbers I mentioned above (154922 & 154980) were still returned, it's just now showing only 13. Also, there could be only one 13 in a job number.
Some jobs have more than one cost center (10,42,12,13) and some jobs only will have cost center...
The job number I mentioned above is good - I want to see this because this job only contains cost center 13, it makes no difference how many 13's there are.
These two job number's below were returned as well, but I don't want these included. If I would put >=1 in the formula these two jobs would...
I moved ahead, following your first post and now I have a report that lists all the jobs with at least one cost center = to 13
Still need to get around the problem I mentioned above.
Thanks.
I have one more little 'glitch' that we need to get around. Below is one of the results that I am seeing after the if-then-else formula.
143009
143009 13 1 390
143009 13 1 395
2
Even though I have 13 = 1 and everything else zero, when I do the sum...
I must apologize - I was using the wrong field. Here is the correction I put in for the Group selection formula:
DistinctCount ({Job Detail (History).Cost Center},{Job Detail (History).JobNo})=1 and
{Job Detail (History).Cost Center}=13
I then re-ran the report and did get some results. I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.