Numerical Values in chart

[#1]

HI All,

in Straight Table values are multiplying with 100 .i am not able to find out . client  want out put as

1,2,3,4 but it showing 0.1,0.2,0.3,0.4  i tried in presentation tab  i ts not working .i there any way to do  this .i u Know plz tell me its aurgent

expression is

=(num(count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date))))*100 &'%'

[PrashantSangle]

Hi,

Just check in Property ->Number -> Show in % is tick or not.

Regards

[sunny_talwar]

Try this and see if this gives an output you are expecting to see

=Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date)))*100, '#,##0.0%')

[amit_saini]

Hi,

Go to chart properties->Number->select your expression and decide the format.(Use as integer)

Thanks,

AS

[#5]

thanks for all response.

i tried

=Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date)))*100, '#,##0.0%')

=Go to chart properties->Number->select your expression and decide the format.(Use as integer)

but still not working

[avinashelite]

can you please share your app

[#7]

is it should i cange total code for this ,and try another code then  it work's plz tell

[PrashantSangle]

In above formula either multiply by 100 or in Num format write %

Try

Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date)))*100, '#,##0.0')

or

Num((Count({$<Date={"<=$(CNo)"}>}Date)/(Count({$<NAME1_LASTNAME,[ GROUP],Date>}TOTAL<Month,[ Year Name]>Date))), '#,##0.0%')

Regards

[sunny_talwar]

As Avinashelite correctly pointed out, it would be easier if we see the application or a sample. Because without seeing it, we are all probably be guessing. Can you share a sample?

Best,

Sunny

[#10]

Changed The Total code still not working:

my Requirement is

document date | Reservation Date | diff Date( document-reservation date) |  input box  |  output

2/1/2015          | 1/1/2015             |    1                                                 |  <=3             input box value/total Diff date*100

3/1/2015          |  1/1/2015            |     2                                                |   1+2+3=6  \         6/11*100

5/1/2015          |  2/1/2015            |    3

10/1/2015        |   2/1/2015           |     5

                                                   11(total)

input box=value given by user <=3  1+2+3(6)

out put:6(input box)/total diff date*100

note;out put should be in integer

its aurgent plzz