1. 

   HVPatel Active Member

   
   Hello Experts
   I have a field in a report
   [Field : field name]
   Use : Amount Field
   Set as : If $$IsDr:$ClBalVarVchDate:Ledger:$VchPartyLedName Then $$LocaleString:"-"+$ClBalVarVchDate:Ledger:$VchPartyLedName else "Nil"
   I am not getting result.
   but getting result without $$LocaleString:"-" it is working.
   Plz. guid.
   Thanks
   -HPatel

    

   HVPatel, Jul 31, 2012

   #1
   
   
   
2. 

   admin Administrator Staff Member

   
   Better Consider field as Number Field
   
   

   Code:

   [Field : field name]
     Use : NumberField
     Set as : If $$IsDr:$ClBalVarVchDate:Ledger:$VchPartyLedName Then $ClBalVarVchDate:Ledger:$VchPartyLedName * -1 else 0
     Format : No Zero

    

   admin, Aug 1, 2012

   #2
   
   
   

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in