Decimal places in standard input schedule templates

[Former Member]

Hi Gurus

I have created some input schedules using standard template. User here will be entering some values in 2 decimal places (like 1.25) but when I enter any values in the cells, it automatically round off the values and displays values without any decimal places.

I have tried changing the formats in Format control panel by changing the DATA / DEFAULT 's PATTERN / ALL for ROWs but it did not help.

Please help how to resolve this.

Cheers

Swathi

[Former Member]

Hi,

The dynamic templates in 7.5 NW are using EVDRE format. In that case, the format is basically defined by the format range. If you just change the format of the data cell, the format range will override. So, you need to change the format of the cells defined in formatrange.

Hope this helps.

[Former Member]

Hi nilanjan,

I tried with Format Range option, but still it displaying the rounded value, (in BPC 7.5)

I need to display the Decimal values. help me

Edited by: SwathiRoy on May 3, 2011 8:07 AM

[Former Member]

Hi,

Please try some other formatting in the formatrange, just to make sure that the data cells are getting the format from formatrange or not.

[Former Member]

Hi nilanjan,

Thanku, I resolved the issue using Format Range option with the below code

CRITERIA EVALUATE IN FORMAT USE PARAMETERS APPLY TO

INPUT ROW 1234,56 ALL -- DATA

Thanku

[Former Member]

Hi Swathi,

Could you please check the settings of Excel.

Excel international setting is related to the display number format only. If you changed the decimal symbol from the regional

setting of Windows, you should log off and log on to BPC Excel and try again.

Regards,

Sanjeev