Modify A Formula

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.

 

Search for VCHAltBilledQty

 

teja ji kindly help about my code plzzz

 

where is your code

 

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

 

I di

i didn't understand the concept can you elaborate with an example

 

kindly try to understand


just set the formulas
minus
plus