How to Define Negative Values as Red

Discussion in 'Requests' started by vumika poudel, Apr 18, 2014.

    
  1. vumika poudel

    vumika poudel Member


    Dear Experts
    How to Define Negative Values as Red Display & Positive Values as Green........... Please Help
    Thanks In Advance

    Color : If $$IsNegative:$Value1 then $Red else $Green .......................????????????????
     


  2. Maulik Patel

    Maulik Patel Active Member


    Dear Vumika Ji,

    Its tricky thing, Kindly try following code.

    Code:
    [Field : MLK Qty]
        Option    : MLK RedQty    : $$IsNegative:$Value1
        Option    : MLK GreenQty    : NOT $$IsNegative:$Value1
     
        [!Field : MLK RedQty]
            Color : Red
       
        [!Field : MLK GreenQty]
            Color : Green
     
    vumika poudel likes this.


  3. laxman

    laxman Member


    and If Value base Field ?

    Dr amount Red
    Cr Amount Green
     


  4. Maulik Patel

    Maulik Patel Active Member


    Then condition behind option will be changed as per your requirements
     


  5. vumika poudel

    vumika poudel Member


    Thank You V Much Maulik Sir................... You r Grrrrrrreeeeeeeeeeeaaaaaaaaaaaaattttttttttttt
     


  6. laxman

    laxman Member



    Report In Target - Achieve =Diff
    i want to if diff value Dr/Cr to color indicate.
     


  7. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member







    i am sharing a line of coding in default tdl


    Local: Field: RP SubAmt: Color: If $$IsDr:#RPSubAmt Then "Black" Else "Red"


    another eg



    [Field: LED eBankingStatementsLocation]

    Use : Logical Field
    Set as: No
    Set always : Yes
    Skip: If #LEDBankingConfigAutoBRSCfg then No Else Yes
    Color: If #LEDBankingConfigAutoBRSCfg then "Black" Else "Deep Grey"
    Sub Form: LED eBankingStatementsPath: $$Value = Yes
     
    Ras Raj likes this.


  8. nasir

    nasir Member


    HOW I CN USE THIS CODE FOR LEDGER RUUNING BALANCE AS RED AND GREEN PLZZZ
    KINDLY SHARE CODE
     


  9. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Color:$$isDr:$$Value Then "Red" Else "Green"
     


  10. nasir

    nasir Member


    JAY KUMAR BAHI HOW CAN WE SET CREDIT SIDE ENTRY IN RED COLOR AND DEBIT SIDE IN BLUE
    KINDLY GUIDE WHAT FILED I CAN USE
     


  11. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Apply in Fields
    Wherever You Required.
    We Can Suggest You But Not Able to Provide A Readymade Solution Everytime.You Should Learn And Make Them As Per Your Requirements.:)
     


  12. nasir

    nasir Member


    its done dont worry bro
     


  13. nasir

    nasir Member


    [Field : MGTotal]
    Use : Amount Field
    width : @@amountwidth
    Set as : $$NettAmount:mad:@LedOpening:$$SubTotal:MGDrCrTotal
    Style : if $$InPrintMode then "Normal" else "Normal Bold"
    Format : "DrCr"
    Inactive : $$IsVoucher AND NOT ##IsCCReport AND @@ShowForex
    Invisible : NOT ##IsLedgerReport


    jay bahi i apply ur color formula here but not working kindly see plzzzzzzzzz
     


  14. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Again You Copy And Pasted


    Use like this...


    Use : Amount Field
    width : @@amountwidth
    Set as : $$NettAmount:mad:@LedOpening:$$SubTotal:MGDrCrTotal
    Style : if $$InPrintMode then "Normal" else "Normal Bold"
    Format : "DrCr"
    Inactive : $$IsVoucher AND NOT ##IsCCReport AND @@ShowForex
    Invisible : NOT ##IsLedgerReport
    Color:if $$isDr:$$Value then "Green" Else "Red"
     


  15. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    If You have done then why are You Asking Again.?
     


  16. nasir

    nasir Member


    i have try this but showing error bad formula
     


  17. nasir

    nasir Member


    done some other things not this
     


  18. nasir

    nasir Member


    i
    ts working thanks bro
    some fields missing

    thanks
     


  19. nasir

    nasir Member


    one thing more bro its showing only in disply
    if iwant to same in print mode then
     


  20. nasir

    nasir Member


    plzzzzzzzzzzzzzz reply
     


  21. nasir

    nasir Member


    its done bro



    Print fg:if $$isDr:$$Value then "Dark Green" Else "Maroon"
    thanks
     


  22. Jay kumar tailor

    Jay kumar tailor Well-Known Member



  23. nasir

    nasir Member


    jay bahi if i have a report and in that field have different data like running expire pending
    how can i assign different color for running expire and pending
    Color:If ??????????
     


Share This Page