BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DandarahZ
Obsidian | Level 7

Hi,

 

After creating calculated items from date-time values, the numerical data that is displayed is accompanied by .00 decimal values. I have tried to format the data. However, that step only works in the data exploration tab and not in the report designer tab. So, how do I remove the decimal values after each of the data? Attached below is the formula that I used to create the table and the outcome after using the formula.

 

Capture1.JPGCapture2.JPG

 

Regards

Dan

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

Hi!

You change the format in the data tab in the report designer.

Select your new variable and click on "Format"

image.png

 

Then select how many decimals you want 🙂

image.png

 

//Fredrik

View solution in original post

1 REPLY 1
FredrikE
Rhodochrosite | Level 12

Hi!

You change the format in the data tab in the report designer.

Select your new variable and click on "Format"

image.png

 

Then select how many decimals you want 🙂

image.png

 

//Fredrik

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1533 views
  • 1 like
  • 2 in conversation