Forum Discussion
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,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])&")")
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] ) ) & ")"
2 Replies
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] ) ) & ")"