I am trying to derive the section header content from another table (Course Details) using LOOKUP() as under:
LOOKUP gives an error as below, even though I have put all four parameters โ see below
Can someone help please
โ Concat Course & Holeโ (Key) as well as โConcat Par & Idxโ are two virtual column in the Course Details table from where I am trying to fetch the value
Please try the expression by putting โ Concat Course & Holeโ , โConcat Par & Idxโ and โCourse Detailsโ in double-quotes in the expression.
LOOKUP(CONCATENATE([_THISROW].[Course id],1), โCourse Detailsโ, โ Concat Course & Holeโ , โConcat Par & Idxโ )
For reference:
Bahut dhanyavad Suvrutt
It worked !
Thanks Steve for the reference
One more question - is there a value I can put somewhere for each column (say a number 1,2,3, etc.) which I can reference in an expression instead of hardcoding the number within the expressionโฆthat way I dont have to go to each expression in each column and change the numberโฆI just copy the expression across each column as isโฆthanks for any help
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |