Problem with num function

[Anonymous]

Hi,

i developed dash board plese find following attachment.

In that when i select the 26th feb 2015 selections it gives exponential values but i have to display numeric values.

Please help me.

Thanks,

[Anonymous]

can you post  your sample data  !! i am using PE

[Anonymous · Accepted solution]

Add some more ### because which you have given are not enough to show all the numbers .

='Call Center'  & chr(13) &

if(MTD='Day',num(sum({$<Date={'$(=max(Date))'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'#,##########')

,num(sum({$<Date={'$(=v_Previous_Date_2)'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,#########')

)

Use this

Thanks

BKC

[Anonymous]

what format should be shown?

if you use '0.000' instead of '#,###' I get a number. correct format?

[PrashantSangle]

Hi,

Try below changes in num()

try below,

num(yourexpression,'##,#00')

instead of ## in end try with 00

Regards

[Anonymous]

Hi balkumar,

  Thanks for your help its help full for me.

Thanks,

[avinashelite]

hi

Mistake is with the num format you have given try like this:

if(MTD='Day',num(sum({$<Date={"$(=max(Date))"},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,###')

,num(sum({$<Date={"$'(v_Previous_Date_2)'"},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,###')

)

format: Num(expression,'###,###')