Skip to main content

Hallo,

 

Why is it the average with 2 decimal places is not capturing the exact decimals? are there any other settings?

 

Below is the Cube setup

 

 

Below is the result in the portal, by right instead of 28.00 it should display 27.60, is there a way to capture the exact value instead of  being round up ?

 

 

 

 

 

 

Please advice

 

Thank you

 

 

Hi Jheng,

The original domain for the underlying column kpi5 likely has no decimals so the result also has no decimals.

Can you verify that this is the case and add the scale to the domain?

Kind regards,

Tim de Lang

Hi Tim,

 

I tried to update the domain to the following data type, but all these failed to see the decimal places

 

  1. using Numeric (5,2) 

 

  1. Using Float
  2. Using Numeric with control 

 

 

The result are all the same, without exact decimals

 

The view table I use the average domain

 

Just also want to share the functionality I used, if this could help to verify

 

This function are used by 2 datamodel view table,

1) Kpi overview (list of data - kpi are just count of days)

2) Kpi graph  (which im using the cube and getting the average of the kpi

 

 

Please advice if there’s anything I missed out to set

 

Thank you

 

Reply


Terms & ConditionsCookie settings