BookmarkSubscribeRSS Feed
mjaitly
Fluorite | Level 6

    Hi

Please see the attached snapshot. I need to do conditional formatting (display rules) on the fields In_time, Out_time and login hours. I cannot convert them to numeric as there are other problems occuring then. Cross Tab report does not allow display rules on category variables but only on numeric.

Thanks

Manish


ConditionalFormatingNeeded.jpg
1 REPLY 1
MichelleHomes
Meteorite | Level 14

Hi Manish,

Is there a reason why you have chosen the CrossTab report object rather than a Table object? As the data items In_time, Out_time and login hours are column headers in the CrossTab they are not available for display rules (conditional formatting), however if you use a Table object you can set up a display rule for the 3 data items. If you require these specific data items to be category you could duplicate them and change the duplicated data item to a numeric too.

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 1811 views
  • 0 likes
  • 2 in conversation