Export to Excel

[neha_sri]

Hi All,

I have a scenario where I have converted my actual values to absolute value using "round" and "fab" like functions in chart,  but I want to export to excel the actual values. Is it possible?

Thanks in advance!

Regards,

Neha

[arulsettu]

i think it is not possible. what ever in the chart it will be exported into excel.

[HirisH_V7]

Hi,

Check the attachment .I hope that Helps.

Thanks,

Hirish

[neha_sri]

Hi Hirish,

I tried your way, but its not working for me.I already have one chart over other and are trigger based.

Regards,

Neha

[raghvendrasingh]

Hi Neha,

Not any direct option for this.but obviously there is workaround:

• You need to to create two chart for the same.
• In first chart show the caption and use expression with actual values.
• In Second chart ,don't show caption and use expression with your functions.
• Then paste the second chart on the first chart making layout as top.

Please try this,I hope this will help.

Regards,

Raghvendra

[neha_sri]

Hi Raghvendra,

I don't want to export using the option given in caption. In my case user will do right click>Send to excel.

In this case we get the absolute value in excel , not actual value.

Regards,

Neha

[miskinmaz]

Hi,

If it is the case where only the user wants to know that this are the negative values and he further don't have to do any calculation, then you can do the following:

1. Remove the round and fab function from your expression

2. Under Number tab, suppose it is a Integer format, then write (#,##0) in format setting. Example: #,##0.00 ; (#,##0.00)

3. Plus you can put text background color, to make to more identifiable.

Regards,

Miskin