Display Decimal Set To 4 But Only 2 Shows On Report for Currency Environment

Goal

Report Design Aid (RDA) rounds up Unit Cost (PRRC, (15,4) at display decimal 2 when dividend (15,2) and divisor (15,4) in Currency Environment for below code,

If F43121.UREC (Units - Received) is not equal to <Zero>

   RV Unit Cost = [F43121.AREC (Amount - Received)] / [F43121.UREC (Units - Received)].

End If

When input values are (where base currency code is USD which has 2 decimal),

• F43121.AREC (Amount - Received) = 543.21
• F43121.UREC (Units - Received) = 1.2345 (where Display Decimal for QTYINV class is 4)
  • Expected Result: 440.0243
  • Actual Result: 440.02

This is functioning as designed.

Display decimals for DD items when currency conversion in for the table trigger:
When the table trigger currency conversion is ON, the MATH operations on those Data Dictionary items which are associated with currency will give results having same display decimals as currency associated DD item. This behavior will ignore the RDA level display decimal override for those DD items associated with currency. We can also associate currency with manual DD item(Not from Business view) by using system function "Copy Currency Information" from ER events. And also If user wants to override DD item display decimals from RDA level, we need to disable the currency conversion from the table trigger.
 

Solution

There is no solution for this as you can see note from development team.

Possible workaround can be,

1. Create one report variable (say RV Temp_Amount_PRRC) using PRRC (15,2) to compute AREC
2. RV Temp_Amount_PRRC = BC Units - Received (UREC) * BC Unit Cost (PRRC) so this is to be represented (15,4)
3. Add Aggregate on RV Temp_Amount_PRRC so RV Total of Temp_Amount_PRRC
4. Compute Average Unit Cost =  [RV Total of Temp_Amount_PRRC]/[RV Total of Units - Received]
5. Hide  RV Temp_Amount_PRRC and  RV Total of Temp_Amount_PRRC