Concatenate Formula Error

[Anonymous]

Hi Experts

Cannot see the wood for the trees.....HELP

HAQNo = CONCATENATE("("&CALCULATE(COUNTROWS(Case_Data),CONTAINSROW({0,1,11,12,13,14,26,28,34,36,39,43,48,49,50,52,53,54,56,57,58,62,63,69,70,71,72,73,74,75,76,77,78,79,82,84,88,89,94,121,131,132,141,144,146,147,183,186,189,204,206},Case_Data[TypeID])&")")

[Stachu · Accepted solution]

you concatenate useing ampersand, there is no need for the formula itself

HAQNo =
"("
    & CALCULATE (
        COUNTROWS ( Case_Data ),
        CONTAINSROW (
            {0, 1, 11, 12, 13, 14, 
            26, 28, 34, 36, 39, 43, 
            48, 49, 50, 52, 53, 54, 
            56, 57, 58, 62, 63, 69, 
            70, 71, 72, 73, 74, 75, 
            6, 77, 78, 79, 82, 84, 
            88, 89, 94, 121, 131, 132, 
            141, 144, 146, 147, 183, 186, 
            189, 204, 206}, 
            Case_Data[TypeID]
        )
    )
    & ")"

[Anonymous]

Arrrrr i se my error now... thanks much appreicated