Hi all,
I am calculating Days to close that is >10
I am getting error in Value while filtering posting date and Days to close.
Posting Date 1/1/2015..12/31/2017
Days to close
="=nf(,""Due Date"")-nf(,""Posting Date"" )" Number&>10
=NL("Rows","Cust. Ledger Entry",,"Posting Date",$E$4,$D$6,$E$6)
PFA for screenshot
Hello Joshua -
I would assume that the contents of cell F8 should be:
=NF("C8","Due Date")-NF("C8","Posting Date")
Is that what is there?
Have you looked at how to use the "Filters=" feature?
Dear Harry,
When I declare F8 as
=NF("C8","Due Date")-NF("C8","Posting Date")
I am getting the record key has been corrupted or invalid.
Hello Joshua -
Modify the function in cell C8 to use the special filter "FILTERS=" to access the filter pair you have placed in cells D6 and E6:
=NL("Rows","Cust. Ledger Entry",,"Posting Date",$E$4,"FILTERS=",$D$6:$E$6)
this should return a valid key.
Dear Harry,
Thank you for ur reply.
I tried like that still i am getting the same error.
Regards,
Joshua.
Joshua -
Please try this in cell C8:
=NL("Rows","Cust. Ledger Entry",,"Posting Date",$E$4,"=NF(,""Due Date"")-NF(,""Posting Date"")","NUMBER&>0")
Dear Harry,
I tried these formula's in another PC its working fine.But its not working in my PC i also installed the application again still its not working.
Regards,
Joshua.
Hello Joshua -
Great troubleshooting!
You now know that the issue is specific to that one machine. Since you have already uninstalled/reinstalled the Jet Excel add-in, this may indicate that there is some issue either with the installation of Excel or some setting on that system.
Your best option would probably be to submit a support request to the Jet Technical Support team so that they can more deeply analyze what's going on with that system.
Dear Harry,
Actually the problem was with Regional date .I changed the date format from MM/DD/YYYY to DD/MM/YYYY and now its working.Thank you for Your support.
Regards,
Joshua.