Number formatting based on the condition

[Anonymous]

Hi All,

I want to format below expression outcome Count(TestcaseId) such that if the Count(TestcaseId)>10000 then the value should be in format of 10k or else a normal number 10000. Eg if number is 12350 then number should be 12.35K else if it is 9999 then it should show 9999 only. Please help.

[satheshreddy]

Hi Jayesh,

use num() for formatting like below

num(count(ID),'#,##0')

Regards

Sathish

[Anonymous]

Could you please explain, what

Count(TestcaseId) >= 10000

means? I get the meaning of the two last rows but don't get, what this row effects. I got a similar problem and your formular works, but I would like to set the values kind of higher for the mechanism.

[Anonymous]

Thanks for your answer Shaddha.

[Anonymous]

Thanks for your answer.

[Anonymous]

Thanks for your answer.

[Anonymous]

Thanks for your answer.

[Anonymous]

Thanks for your answer.

[Anonymous]

Thanks for your answer.

[Anonymous]

Thanks for your answer.

[Anonymous]

Thanks for your answer.