Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
Hi Aanand
this is qlikview syntax?
Hi,
Yes these are the qlikview syntax's
Fabs(Sum(Metrics))
and
Sum(Metrics) * -1
Thank you
although I was looking to solve the issue in excel
I have changed my expressions and solved the issue
Regards