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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 1825 views
  • 0 likes
  • 2 in conversation