help

Discussion in 'Requests' started by laxman, Dec 17, 2013.

    
  1. laxman

    laxman Member


    Dear

    हमने लेज़र में नया फील्ड बनाया टारगेट। और एक रिपोर्ट बना रहे है (टारगेट - डेबिट अमाउंट =फर्क) हमें आपसे इसमें यह मदद चाहिए कि टारगेट कि वैल्यू जिस दिन हैम देख रहे हो उसको डिवाइड करके दिखाए। जैसे टारगेट 5000.00 है और इसकी रिपोर्टिंग date 30/04/2013 है तो 01/04/2013 से 30/04/2013 तक यानि 5000/365* स्टार्ट डेट तो एंड डेट (राउंड) = 411.00
     


  2. Maulik Patel

    Maulik Patel Active Member


    Dear Sir,

    ($$Number:($$Date:"31-Mar-2013" - $$Date:"01-Mar-2013")) + 1
    will return you difference of start date and end date (31)

    SO

    5000/365 * (($$Number:($$Date:"31-Mar-2013" - $$Date:"01-Mar-2013")) + 1)

    will return your answer 411
     


  3. laxman

    laxman Member


    Thank you Mr.Maulik patel , but formula set in one time
    and reporting time user defined particle date period calculation
     


  4. Maulik Patel

    Maulik Patel Active Member


    Dear Sir,

    If you are using default date period selection of tally then you can use

    (($$Number:(##SVToDate - ##SVFromDate)) + 1)

    Rest things you have to do by your own, as only you knows exact requirements.
     


  5. laxman

    laxman Member


    thank you very much its working.......
     


  6. laxman

    laxman Member


    dear experts i created one more report "Birth date Udf Add In Ledger master " and Showing Particle Udf (Birth date) Column in our reporting but searching option in missing please help Search Button option ?
     


  7. mpal2311

    mpal2311 Active Member


    Can you please upload the codes.
     


  8. laxman

    laxman Member


    yes file is working but need search button
     

    Attached Files:



Share This Page