How to combine columns in Smartlist Designer

(0) Share

Report

Posted on by Brenda Willey

2,510

I would like to create a Smartlist that combines to PayCodes into one column. We have Sick time for both Salary and Hourly employees. I would like to present these as one column. no employee would have both at the same time. I'm thinking I should be able to create a calculated field but not sure of the formula since I really don't need to add them together.

*This post is locked for comments

All responses (3)

Answers (0)

soma 24,406 on at

Like (0)

Report

RE: How to combine columns in Smartlist Designer

Can you provide the sample data with table format? This will help us to give you solution for your requirement.

Your reply is much appreciated.
Brenda Willey 2,510 on at

Like (0)

Report

RE: How to combine columns in Smartlist Designer

I ended up working with one of our technical people and he created a SQL view. There is not an easier way to combine the leave codes.
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: How to combine columns in Smartlist Designer

Hey Brenda

Are you sure Salary and Hourly employees comes in two different columns not rows ? It would be highly appreciated if you share a sample data of this smart list to help you build the calculated field.

Furthermore, in case this is a customized report. Modifying this on the SQL level comes as an easier choice.

Your feedback is highly appreciated,