Forum Discussion
rhborders
Helper I
Helper ILooking up multiple values
Hello, In our database we have a schema that tells us what date we get an invoice and then another dates schema that converts calender days into a fiscal day of year. For example if we got an in...
You can use lookupvalue function to make it happen.
Let me know if you need further assistance on this function
rhbordersHelper I
Helper IFiscal Mean is a calculated column and there is not a direct relationship between the two
parry2k
Super User
Super UserYou can use lookupvalue function to make it happen.
Let me know if you need further assistance on this function
- rhborders
I had tried this before and only got partial results. Some of my records are blank when all should be full. I reran and had the same issue. Any idea as to why this may be?
- parry2k
Can you share example where you get the blank result and also if there is corresponding record in date table?