How to display order total in separate column of excel report?

Hi guys, I have created a report in excel but its not quite what I'm after, wanting to know if there is away to do this;

- Payment Amount is in a column on its on (currently it has a column which has "Total Amount (Amount: 400.00 AUD)

Total: 400.00") Id like it to just have "$400"

Reason for this is i have a database I would like to import this into and the current formatting won't work for me

cheers

Jordan

Hello Jordan,

Do you mean to say that you want to display the order total in a separate column of excel report? 

Unfortunately it is currently not possible to display products and order total in separate column of excel report. Please note that the product selection, order total and payment information are displayed together in one single column of submission & excel file. 

Please confirm if this is what you want to achieve, we will create a feature request ticket and forward it to our backend team.

I have moved your second question to a new thread so that we can address it separately. You will be answered in the following thread:  https://www.jotform.com/answers/1114752

Thank you!

Hi Ashwin, yes this is correct. It means I can import a batch of orders into a system we are using. Currently we are having to enter them manually which is quite time consuming.

Thanks :)

I have just created another hidden field on my form that contains the same payment value as the actual payment field. This will come out on its own column in excel.

Problem solved :)

Jordan