0

Function which evaluates fine, returns #Value

Hi All,

I am a bit confused. I am working on a report running on a SQL-Server database (not Navision).

The problem is in the following formula:
=NL("Rows";"Resources";;"DataSource=";$I$5;"ResKey";NL("Filter";"Contracts";"ContractResKey";"Datasource=";$I$5;"ContractStart";"<="&TEXT($K$9;"yyyy-mm-dd");"ContractEnd";"=1900-01-01|>="&TEXT($I$9;"yyyy-mm-dd");"ContractCatKey";$D16);"ResLocKey";$I$6)

In the cell, this formula returns a #VALUE! error, but as you can see in the picture below the formula evaluates fine in the Function Wizard:


To be honest, I don't know how to solve this.
Any help is greatly appreciated.

Best regards,
Gerard

    1 comment

    Please sign in to leave a comment.