Set analysis

[Anonymous]

Hi,

  when i am using num(sum({1<Date={'$(=v_previous_date)'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'#,###')

i got 4.638e+005 value but i have to display numeric value ..

Please help me,

Thanks,

[anbu1984]

Can you post sample app

[#3]

This usually happens to me when I format the number incorrectly.

Example:

=num(325236,'#,##')

returns: 3.25e+005

But when I use '.' instead of ',' I get the correct number.

So are you using the correct separators? As defined in your script?

Something like #.###,## might work.