Solved, thanks 10 Centuries!!!!!!!!!

I want the sum of each of those column per record.

If each has 10.oo, I want 50.00.  but all columns arent all populated.

thanks

SELECT *
INTO #tempValue
FROM
(
SELECT
--TRY_CAST(t.HTS_98_Value AS NUMERIC (10)),
--try_Cast (t.HTS_99_Value AS NUMERIC (10)),
--try_cast (t.HTS_B_Value AS NUMERIC (10))
--try_cast (t.HTS_A_Value AS NUMERIC (10))
--try_cast (t.HTS_C_Value AS NUMERIC (10))
SUM(TRY_CAST(hts_a_value AS NUMERIC) + TRY_CAST(hts_b_value AS...

thanks.

Any non numeric value can be treated as a 0.

I did try try_cast . . (with just using two values in the SUM)

SELECT
TRY_CAST(t.HTS_98_Value AS NUMERIC) AS 'HTS_98_value',
try_Cast...

the tables contain more than 1 Importer and records go back years. I only want the row counts for the filtered results.

I believe i need to use STUFF and/or XML functions but get lost in the weeds.

CLARIFICATION:

I am getting the error on THIS rownum... in the WHERE CLAUSE on the above code;

where Z.SUB_ORG = 'FUDGE'

AND RowNum = 1

and Z.CREATED_DATE > '1/1/2018') AS entry

SOLVED - ZATS is HUGE and i didn't have a Where clause on iMPORTER

SOLVED . . . . . i had a second tablix with just thew Row Count . . .but i didnt remove the DETAIL below

Thanks, actually i tried both. you can't put a text box in Footer . . and the rectangle didnt work.

thanks though

Yes I did. Did you read mine?

thanks

i executed several reports, none prompted me . . .

i went to

Tools/options/SQL Server/Results to text

selected my options and said ok....

did i miss something??

thanks

i did put brackets around the YEAR field.... the tables over [YEAR]

That was it!!!  I actually printed your reply and pinned it to my cube!!!!!!!!!!

Thanks so much

I used "distinct" to make it clear that I had no duplicate values.