** SOLVED** Last() formula not working

I'm writing this in my phone so I don't have any screen shots. Here is the issue...

I have a table being displayed on a gallery. The table is from sharepoint and it's called BuyoffSubkit. When click the record on the table the OnSelect set that record to varOnChangeRecord. The on the same screen, you then write a DCN and part number. The button at the bottom of the screen is supposed to get some information from the varOnChangeRecord and the rest of the data from the txtinput fields to make a new records on another table on the screen. The table is called BuyoffInspection. Now, critically what I need to have happen is that for every record on the BuyoffSubkit table it shows what the subkit number is corresponding to the title field. But on the BuyoffInspection table, each record needs to have a sequence number corresponding to the number of DCN's added. So within my patch, I tried to set up the If() statement that states in normal speak: "if you can't field a title And subkit number that matches varOnChangeRecord, then the sequence number is 1."

Then I started writing the "if false" portion of the If() and it will not work!

I was trying to do something like this:

Last(LookUp(BuyoffInspection, varOnChangeRecord.title = title, And varOnChangeRecord.subkit_name = subkit_num), subkit_num)

Or it was something like that. When I do just the LookUp() in a label field, I actually get a "1"... because it's finding the first record for that title and subkit. But had manually built 2 records in sharepoint to test formula so I thought using Last() would display 2... but it doesn't. And I've tried filtering and sorting... and I just have no idea why it won't show me the last subkit number for that kit and title!

Please let me know what I've done wrong!

9 comments