Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Concatenate Formula Error

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...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    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]
        )
    )
    & ")"
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

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