Inv. Totals by Multiples of 6 1

[ZENYO]

Can this be done? I would like to write a report that will show all line items where the total is a multiple of 6 (i.e. 6, 12, 18, 24, 30 etc...). Can this be done?

Thanks
Al

 

[synapsevampire]

If you mean that this total is a field within the table, you could use the following in the Report->Edit Selection Formula->Record:

remainder({table.total},6) = 0

Since you've used the term total, you may want something like the following (I think it would work, can't test right now):

Group by the appropriate entity that you're totaling on.

In the Report->Edit Selection Formula->Group place:

remainder(sum({table.fieldtosum},{table.fieldtogroupon},6) = 0

Generally successful posts include technical information rather than just descriptions:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[ZENYO]

Ok, Reading my post... not sounding to good, sorry. Let me try again...

I would like to construct a report that will allow me to pull invoice totals that are multiples of 6.

Within the Invoice table there is an InvoiceTotal field. the invoice total field can be any value 1, 65, 32, anything... We want to know, who orders by CaseLots (6).

What kind of technical info? We are using Crystal 10, database is on SQL.

Thanks for your help

 

[synapsevampire]

The technical information that most supply is what I'd listed above.

Did you try my suggestion, it looks like what you want:

Use the following in the Report->Edit Selection Formula->Record:

remainder({table.total},6) = 0

or you can use:

{table.total}/6 = int({table.total}/6)

-k

 

[ZENYO]

That's exactly it! Thank you very much!

 

[ZENYO]

What's the = 0 doing?

 

[Madawc]

12 divided by 6 is exactly 2, 13 divided by 6 is 2.1666 etc. That's what remainder means - whatever's left ovee from a division and is less than a whole number.

Madawc Williams (East Anglia, UK)