hi expert i dont know if this is correct please help me..
i have a 3 rows in JDT1
Account Linememo
4027 Cancellation
4027 Ayx001
4027 Ayx001
OINV
i want to display the U_40STD field UDF of AR-Invoice - e.g. U_40std = 2 so that i want to display 2
here is the code
if {JDT1.Account}= '4027' and Instr({JDT1.LineMemo},'Cancellation') = 0
then {OINV.U_40STD}*2 else 0
Output
2
2
2
But i want to display 2 only or one row only because if i used the suppress if duplicated when i summarize it will give total of 6. i want 2 instead...
thank you very much
regards
silent