1 Reply Latest reply on Aug 6, 2014 7:43 AM by beverly

    Excel Export records

    ashutoshshah

      I am not getting correct data while exporting records in excel sheet. Please have a look on following example and help me out :

       

       

      Holder name loan amount

      abc $15000 (Summary field which has fields values as $5000,$10000 so, $5000+$10000=$15000)

      xyz $60000 (Summary field which has fields values as $5000,$10000 so, $50000+$10000=$60000)

       

       

      Now,

       

      if I am exporting records means using "Save Records as PDF[No Dialog;Records that are being browsed]", it is displaying the same output as expected i.e. -

       

      Holder Name Loan amount

      abc $15000

      xyz $60000

       

      But if I am exporting records means using "Save Records as Excel[No Dialog;Records that are being browsed]", it is displaying the same output as expected i.e. -

       

      Holder Name Loan amount

      abc $15000

      abc $15000

      xyz $60000

      xyz $60000


      The reason is they are summary fields, and for excel export it is not displaying the same format.

       

      Please help me out.