when export to excel it showing as Text not number

[SunilChauhan]

Hi all,

I have one table when i am exporting from server .it sent to excel as Text not number. but we want in number .

please find the expression

If(ApplDashboard.FunctionLeve3='ACA'  ,

Num(Count({<ApplDashboard.FunctionLeve3=,ApplDashboard.FunctionLeve4,ApplDashboard.FunctionLeve5=,ApplDashboard.Rating=>}

distinct [ApplDashboard.Plan]),'#,##0'),

If(ApplDashboard.FunctionLeve3='SUES',

Num(Count( {<ApplDashboard.FunctionLeve3=,ApplDashboard.FunctionLeve4,ApplDashboard.FunctionLeve5=,ApplDashboard.Rating=,ApplDashboard.QuarterNum={"$(=Max(ApplDashboard.QuarterNum))"}>}

DISTINCT [ApplDashboard.Issue ID]),'#,##0'),

If(ApplDashboard.FunctionLeve3='REACHES',

Count({<ApplDashboard.FunctionLeve3=,ApplDashboard.FunctionLeve4,ApplDashboard.FunctionLeve5=>} DISTINCT ApplDashboard.ID1),

If(ApplDashboard.FunctionLeve4='Resid'  ,

num(Only( {<ApplDashboard.FunctionLeve3=,ApplDashboard.FunctionLeve4,ApplDashboard.FunctionLeve5=,ApplDashboard.Rating=,

ApplDashboard.Year=,ApplDashboard.Quarter=,[ApplDashboard. Due]=,

ApplDashboard.Region=,[ApplDashboard.Business/Function]=>} $(vRating)),'#.#'),

if(ApplDashboard.FunctionLeve3='NEPS',

Count({<ApplDashboard.FunctionLeve3=,ApplDashboard.FunctionLeve4,ApplDashboard.FunctionLeve5=,ApplDashboard.Rating=>}

DISTINCT [ApplDashboard.ID2]),0))))

in chart properties-> number-> expression as Default.

what may be the reason it export in