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
Sunil Chauhan
