Number

[smilingjohn]

Hi ALl,

IN my table iam getting the output as  shown in the Screenshot..

My requirement is like  it should not show any decimal when it is zero ..

other than that it should show decimal for other number ..

how do i format this ?

Thanks

[devarasu07]

Hi,

Method1:

by default it should give expected result. Try to set expression default option or Number radio button under Number tab - chart object

Method2:

Try like this

if(Mod(Sales,1)=0,num(Sum (Sales),'#,##0'),num(Sum (Sales),'#,##0.0'))

[smilingjohn]

Hi , Expertise

I got that thing resolved by giving

### in the number format ..

As shown in the screenshot i want to bring this negative values in the top..under sorting .

please need your help to achive this ...

Iam using this  expression to achive this ..do i need to make changes in this expression to achive the begative values in the forst row or shuld i do it in the sorting ?

sum(Expensed)-sum(Claimed)

Thanks in advance

[devarasu07 · Accepted solution]

Hi,

Just try to enable ascending sort order for that calculated measure column (i.e in your chart object--> sort tab )

[smilingjohn]

HI Devarasu,

This is not getting enables ?

Its graded out ..

What should i do  sir ?

Thanks

[devarasu07]

Hi,

Would be able to share your app /mock document? tks