EVDRE scaling / formatting problem
I have a problem with the representation of my data in BPC Excel.
If I build input or report schedules and use the EVDRE() function, all data values are multiplied by the factor 10,000,000.
For example, I send the value "4,000" via an input schedule and refresh my worksheet afterwards. Then the workbook shows the value "40,000,000,000" instead of "4000". Nevertheless, the data value in the database itself is correct because if I retrieve the value via the EVGET() function I get the correct value "4,000".
I tried almost everything including different settings concerning cell formats, but the problem remains.
I appreciate your help very much!