Recent content by brecat77

what do you know about WhilePrintingRecords

i not sure of the problem. it is still doing the same thing. it will not just sum the visible ext price

emailed. thanks

the line type 0 is the actual number im trying to sum. so when i take the others out 930, 928, ect and put 0 in there it totals fine. just it is totaling everything, even what is not showning. i only need it to total what is visibly showing and it is driving me batty.

when adding if {invoice_line.invoice_line_type} in [928, 929, 930] then {invoice_line.extended_price} else 0 it still is 0 when summed. i have added a screen shot for your reference.

still getting the "formula result must be a Boolean

this will be placed in the section correct?

This is what i was suppressing in the section. //{invoice_line.invoice_line_type} = [928, 929, 930] //OR //{invoice_line.item_id} = 'FINANCE CHARGE' in select expert {invoice_hdr.invoice_date} in {?Beginning Date} to {?Ending Date} and {address.delete_flag} = "n" and {invoice_hdr.customer_id}...

I am trying to sum a field, but i only want the sum of the visible selection. help please.

so to put the dates within a range to go from 6am to 6am how would that formula show? I'm still having trouble with it. This is my current formula {TRANS.TypeDescription} = "ISSUE" and {TRANS.Transdate} = dateadd("h",6,datetime(currentdate)) to dateadd("h",-18,datetime(currentdate)) and...

I need to figure a formula to give me currentdate from 6am to currentdate-1 6am. any help is appreciated

that works great except that if i put anything into the field of ({INVENTRY.IssueUnitOfMeasure}) it multiplies it by .3048. such as MT is in there for about 6 items, the rest are blank, this is fine, but if i put in anything into the field of ({INVENTRY.IssueUnitOfMeasure}) it multiplies it by...

IF ISNULL ({INVENTRY.IssueUnitOfMeasure}) THEN {TRANS.quantity} ELSE {TRANS.quantity}*.3048 my problem is this, i only need {TRANS.quantity} to multiply by .3048 if the ({INVENTRY.IssueUnitOfMeasure}) is = MT otherwise i need it to just be {TRANS.quantity}. Any help here would be greatly...

i ennded up using the following formula and it worked if {oe_line_1000.budget_code} startswith "P" then left({oe_line_1000.budget_code},5) else left({oe_line_1000.budget_code},4)

fixed