Hi, Jagan,
The last image doesn't look like it reflects the same lookup table. When you reference a lookup table, the parameters are a calendar date, followed by a parameter for each dimension.
In the example here, your lookup table has two dimensions, Sales Status and Bonus Level. So the reference would look like this:
The Date parameter needs to be an exact calendar date, not a period. You could use the Fiscal Date function to return the last day of the current period; so for January 2022 the result would be January 31, 2022 or 01/31/22.
In this example, both the Sales Status and the Bonus Level are generic attributes on the Participant record, so the populated parameters would look like this:
One more thing that will make this easier is to store the completed expression in a formula so you can reuse it. I hope this helps!
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.