How to refer any particular cell or range of few cells irrespective of entity codes in nexel?

Vanam Pavan Kalyan

Hi Team,

I am facing an issue with nexel function, I have table with two blocks with month as column

Now i am trying to refer the 1st cell of the 1st block which means in Jan column to 1st cell of second block

in the same way i need to sum of all 12 months and display it in 2nd cell of the 2nd block

Now I can easily do this for only current month, i facing issue while making it dynamic

can anyone please help me in this.

Thank you for your support

Jeff Williams

Hi Vanam,

Thank you for your post.

From your description, we understand that you are trying to use the NEXEL function to dynamically reference the first cell of the first block (e.g., January) in the second block and calculate the sum across all 12 months. To better understand the scenario, could you please let us know if this is part of a Board Academy training exercise or your own Board environment?

• If it's a Board Academy exercise, please share the course name, module, and lesson where you're encountering this issue.
• If it's in your own Board environment, please provide your Board version, instance name, Data Model, Screen, and a screenshot of the layout along with the NEXEL formula you're currently using and the expected result.

If the issue is related to your own Board environment, we will create a support ticket so that our Support team can investigate it further.

We look forward to your response.

Regards,
Jeff Williams