Variable Declaration Error
Hi,
I have two tables named [Startup] and [Fund]. There is no relationship with the tables. I want to fetch the allotted fund value based on the financial year of the startup from the startup table...
Forum Discussion
I'm not 100% sure what the formula errors specifically are alluding to - but from reviewing your formula they syntax in general looks off. I would suggest trying the following and seeing if it responds differently:
var text FY = [Financial Year];
If ($FY != "",
(GetFieldValues(GetRecords("{6.EX.'" & $FY & "'}", [_DBID_TANSIM_FUND]),8)),
null)
The 2 changes are:
1. Change $FY != null to "", since FY is text you need to compare it to blank text
2. In your query - you have the $FY inside of the '' as if that was the value. Break out the variable from the string by doing '" & $FY & "'
You might also have to do a ToNumber or ToText function around the query as the response from queries is a multi select value that you likely need to convert.
------------------------------
Chayce Duncan
------------------------------
Hi Chayce,
Thanks for responding. I have tried your code. Still, it throws the same error. I have attached an image for your reference. Please advise on this.
------------------------------
Prakash Murali
------------------------------
