I have a report with the following formula
{PD_CDDPDRATRANW_RECORD.TRX_COST_CTR} = 7070 and
{PD_CDDPDRATRANW_RECORD.TRX_POSTING_DT} in LastFullMonth and
{PD_CDDPDRATRANW_RECORD.TRX_QTY} > 100
I will then as time goes by have to exclude some data if it meets certain criteria and I'm not sure how to add it to the formula
I will want to add if {PD_CDDPDRATRANW_RECORD.TRX_PROC_NO} = 2792017 and the {PD_CDDPDRATRANW_RECORD.TRX_QTY} of that proc no <> 150 to print the line data to the report but if the line data matches this criteria then I don't want it to print to the report.
I will also have to add other trx_proc_no and trx_qty to the report such as
if {PD_CDDPDRATRANW_RECORD.TRX_PROC_NO} = 2700115 and the {PD_CDDPDRATRANW_RECORD.TRX_QTY} of that proc no <> 130
The trx_proc_no and trx_qty will/could be different for each exclusion.
Where do I add these exceptions and how to I formulate them?
IP Logged
