Hello Sir i want to modify a formula [#Field: CI Value] COLOR:BLUE QtyCalc : $$Total:VCHBilledQty * $$Owner:$$AsRate:#CIAccRate i want to multiply alternate qty total instead of VCHbilled quantity total please help me.
see code plzzz [#Part: EXPsmp Totals] Add :Lines:InvBal1, mmjan,InvBal2, InvBal3 [Line:Tarif] Field : Trif [Field : Trif ] Use:Name Filed Set as : "Trif : " Style : normal BOld [Line:mmjan] Field : mmjan , mmjan02 [Field:mmjan] Use:Name Field Set as:"Total Dues With In Due Date:" Width:25 Invisible:Not ##InvBalPrint [Field:mmjan02] Use:Amount Field Set as: ":_______";;;;;#EXPINVTotal Align:Right Format:"Symbol,DrCr" Border:Thin Bottom Invisible:Not ##InvBalPrint [Line:InvBal1] FieldsreBal, SepFld, PreBalAmt [FieldreBal] Use:Name Filed Set asPreBal Align:Left Width:25 Invisible:Not ##InvBalPrint PreBal:IF $$IsDr($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) - $$abs:#EXPINVTotal) + Then "Arrears" Else If $$IsDr($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + $$abs:#EXPINVTotal) + Then "Advance" Else "Advance" [FieldreBalAmt] Use:Amount Field Set as: @PreBalAmt Format:"Symbol,DrCr" Invisible: Not ##InvBalPrint PreBalAmt: If ($$IsDr:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + Then($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) - $$abs:#EXPINVTotal else + ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + $$abs:#EXPINVTotal [Line:InvBal2] Fields:InvAmtTit, SepFld,InvAmt [Field:InvAmtTit] Use:Name Field Set as:"late payment fee charges" Width:25 Invisible:Not ##InvBalPrint Align:Center [Field:InvAmt] Use:Amount Field Set as: Format:"Symbol,DrCr" Border:Thin Bottom Invisible:Not ##InvBalPrint [Line:InvBal3] Fields:InvNetTit, SepFld,InvNet [Field:InvNetTit] Use:Name Field Set asNetBal Width:25 align : Left Invisible:Not ##InvBalPrint NetBal:"Total Dues Afetr Due Date" ;;;IF $$IsDr$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + Then "Net Receivable" ELSE "Net Advance" [Field:InvNet] Use:Amount Field Set as: "_______";;;;@InvNetAmt Format:"Symbol,DrCr" Borderouble Bottom Invisible:Not ##InvBalPrint InvNetAmt:$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries [Field:SepFld] Use:Name Field Set as:":" Width:1 Space Left:0.1 Space Right:0.1