cancel
Showing results for 
Search instead for 
Did you mean: 

Export to excel problem

anshu_lilhori
Active Contributor
0 Kudos

Dear All,

I have a field in report called dispatch date which has been made with the help of formula variable using replacement path.

Now the issue is when i try to export this report to excel the value of dispatch date becomes zero,whereas it shows the correct value in RSRT and analyzer.

For your information i have other date fileds too but they shows the value when exported to excel. I think there is some dependency when we use formual variable with replacement path.If someone has faced similar issue then plz provide me the inputs to resolve it.

please help me out with this issue.

Thanks in advance.

Regards,

AL

Accepted Solutions (0)

Answers (2)

Answers (2)

anshu_lilhori
Active Contributor
0 Kudos

Need to implement note given by sap

Former Member
0 Kudos

this is a funny error which is generally faced.

do let me know whether your actual value is less than 1 or not...

if yes then create CKF and multiply the above value with 1.0.

anshu_lilhori
Active Contributor
0 Kudos

Dear OP,

As i already mentioned its date field so its in date format..Now please update on the same if you have any clues..

former_member189638
Active Contributor
0 Kudos

Try using a customer exit variable rather than a Replacement path variable and check if still the problem exist?

anshu_lilhori
Active Contributor
0 Kudos

How to use it..Can you me walk me through the steps..