Goodmorning my fellow IDEA users,
I'm having a relatively simple problem (i think) but it is driving me crazy:
I'm trying figure out if it is possible to refer to a single record in the Equation Editor like it is possible in Excel with prefix $ in a cell?
Thanks in advance
Dino
Dino
Offline
Last seen: 5 years 7 months ago
Joined: 02/08/2018 - 02:45
Hi Dina and welcome to the site.
Unfortunately it isn't possible to do that in the equation editor. You can only refer to the information in that record or with the @GetNext or @GetPrevious you can get information for the adjoining records. For something like this you would have to hard code it. Now you can do something like this using IDEAScript as their are functions in the scripting language to read a particular cell and then insert that value into an equation.
Brian
Hi Brain, Thanks for the quick reply.
I will look into IDEAScripting for a possible solution
Dino
Let me know if you need some help.