KrisNori, I just tested this in VA 7.3 Designer and it worked fine for me. I created a LASR table by importing a small excel file and then created the calculated item using your formula. What does the table look like in VA for you? My screen shot shows the new item and the values to the left. Shannon
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.