How to use CAST in BAQ for two seperate Deduction Rates - Or combine rows

Epicor ERP 10
,
1

I might have left out some details but I’m trying to list our employee “Deductions” for 401K and Roth. Some employees have both deductions and some do not. When I make my report, I need to be able to display both results as a single row, not having the Employee name show up twice.

Trying to use cast like this.

image
image920×600 30.8 KB

I’m still getting this result.

image

If i can get them into the same field I can seperate them in SSRS. I doubt I can seperate them in different columns using BAQ and still only have 1 employee row. I tried using sub-query already. Not

I’ve been struggling on this all day. Argg…

image

image

It’s forcing me to do a group by on the “Calculated_Cast” field which is probably part of it.

image
image820×107 6.32 KB

2

two ways I would try and do this.

not sure you will need to cast though…

create two sub queries
one for roth by employee
one for 401k by employee
join them back to the employee

or

create two calculated fields which would select the field directly from the table.
one which selects the Roth data
one which selects the 401k data

1 Like
3

Thanks for the ideas!

4

You did it! Thanks a bunch!
image

image