Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Just try to enable ascending sort order for that calculated measure column (i.e in your chart object--> sort tab )
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'))
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
Hi,
Just try to enable ascending sort order for that calculated measure column (i.e in your chart object--> sort tab )
HI Devarasu,
This is not getting enables ?
Its graded out ..
What should i do sir ?
Thanks
Hi,
Would be able to share your app /mock document? tks