Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
Conversions
I have a column which I formatted as :"#,##0.00"
The money data is stored as MD4.
The output differs between "MD4," and "MD4" ie with and without the comma.
The values are scaled incorrectly.
It seems the format also performs the conversion, and the comma confused it.
I just removed the comma from the OCONV and let the format do its job and all is OK.
Mentioning here for any others if needed.
ColumnList<-1>="Estimated Price":@VM:"Number":@VM:"100":@VM:0:@VM:1:@VM:0:@VM:1:@VM:1:@VM:@VM:"Right":@VM:@VM:"#,##0.00"
IF ColEstPrice THEN LINE<1,ColEstPrice>=OCONV(ITEM<37,1>,"MD4")
The money data is stored as MD4.
The output differs between "MD4," and "MD4" ie with and without the comma.
The values are scaled incorrectly.
It seems the format also performs the conversion, and the comma confused it.
I just removed the comma from the OCONV and let the format do its job and all is OK.
Mentioning here for any others if needed.
ColumnList<-1>="Estimated Price":@VM:"Number":@VM:"100":@VM:0:@VM:1:@VM:0:@VM:1:@VM:1:@VM:@VM:"Right":@VM:@VM:"#,##0.00"
IF ColEstPrice THEN LINE<1,ColEstPrice>=OCONV(ITEM<37,1>,"MD4")
Comments
I think your observation is correct. The ReportTable employs Excel-style formatting, which includes the comma symbol. The data in the ReportTable is expected to already be in an OCONV state but without any formatting other than the decimal point in the correct location.