Hi all
I want my measures to be exported(Excel) as numbers instead of text.
When i simply use them as is it does this correct but as soon
as I as the following number formating it no longer exports
correctley.
=FormatNumber(Fields!Example.Value,2,True,True,True)
The same apllies to whe I set the formatting in the text box properties to N
Can some please tell me how I can acheive this result when exporting
Thanks in advance
G
Apply formatting using N in the Format property, then in the value textbox, apply an explicit cast of the value. E.g.
=CDbl(Fields!Example.Value)
Bizzare, but I've found this to work for me.
|||Thanks Adam
I came accros the same thing today when i was casting
the values returned from custom code. I just hope the same
principal will aplly to currency.
In my case I had to figure to use N0
as format type to get 1,345,456
When using the cdbl() to do this you cant use FormatNumber(,,,)
that was my snag.
Thanks again for your time
G
