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-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 1225 views
  • 1 like
  • 2 in conversation