Exporting to excel

[rido1421]

HI All

I have a model with an income statement in a chart using a UDR

When i export to excel the figures in brackets - the negatives come through as text... I need them to come through as a number

is there perhaps a way to convert this in excel? i think it would be easier for me to show my end user how to do this instead of change all my expressions

I have attached the file ...

Regards,

[its_anandrjs]

Hi,

In expression use Fabs for ignore negative values

Ex:-

Fabs(Sum(Metrics))

Or

Sum(Metrics) * -1 //if there are only ( - ive )values

Regards

Anand

[rido1421]

Hi Aanand

this is qlikview syntax?

[#4]

Hi,

Yes these are the qlikview syntax's

Fabs(Sum(Metrics))

and 

Sum(Metrics) * -1

[rido1421]

Thank you

although I was looking to solve the issue in excel

I have changed my expressions and solved the issue

Regards