Attribute against forecasted value displayed as decimal

Mandar -Oracle

Summary:

In DV report , while building report ,attribute result showing decimal while data is varchar

Content (required):

HS2 Code which is the character data & having values as 01,02,03,04 ( not as 1.0,2.0,3.0,4.0 etc) but in DV it is showing as 1.0 ,2.0 against forecasted values

Version (include the version you are using, if applicable):

5.9

Code Snippet (add any code snippets that support your topic, if applicable):

FORECAST("TRE_MOD"."Fact_V_GREEN_LANE"."DUTIABLE_VALUE", ("TRE_MOD"."Dim_D_DAY"."CAL_PER_NAME_MONTH"), 'forecast', 'modelType=arima;numPeriods=%1;predictionInterval=70;', 3)

Anirban Basu-133546

Hi Mandar ,

Can you check if the datatype is set correctly in data preparation tab .

Thanks

Anirban

Mandar -Oracle

Hi Anirban ,

Thanks for your reply .In RPD , the datatype is set as Char .

Also for more information showing result of HS2 Code as below .

Actual - In May 22

Forecasted : June 22 (After May)

Joshua C. Stewart

You should be able to manually change the appearance of these values to remove the decimal. If you select the Measures tab then navigate to your measure and change the Number Format, you can remove the decimal.