Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NotImplementedError for (CORREL, MEDIAN, SLOPE, PRODUCT, PMT, PV, RATE, DATEDIF, WEEKDAY, WEEKNUM) functions #87

Closed
frmZtH opened this issue Sep 1, 2021 · 2 comments
Assignees

Comments

@frmZtH
Copy link

frmZtH commented Sep 1, 2021

Describe the bug
It seems that the some functions do not seem to be supported.
Such as (CORREL, MEDIAN, SLOPE, PRODUCT, PMT, PV, RATE, DATEDIF, WEEKDAY, WEEKNUM).

To Reproduce
func = formulas.Parser().ast('=MEDIAN(A1,A2,A3,A4)')[1].compile()
func(1, 2, 3, 4)

Expected behavior
It should return value.

Screenshots
raise NotImplementedError
NotImplementedError
During handling of the above exception, another exception occurred:
raise DispatcherError( schedula.utils.exc.DispatcherError: ("Failed DISPATCHING '%s' due to:\n %r", 'MEDIAN', NotImplementedError())

Desktop (please complete the following information):

  • OS: [Windows 10]
  • Version [1.1.0]
@vinci1it2000 vinci1it2000 changed the title NotImplementedError for (CORREL, MEDIAN, SLOPE, PRODUCT, PMT, PV, RATE, DATEIF, WEEKDAY, WEEKNUM) functions NotImplementedError for (CORREL, MEDIAN, SLOPE, PRODUCT, PMT, PV, RATE, DATEDIF, WEEKDAY, WEEKNUM) functions Dec 17, 2021
@vinci1it2000 vinci1it2000 self-assigned this Dec 17, 2021
@sada1993
Copy link

Also noticed this with the ADDRESS function in excel.

vinci1it2000 added a commit that referenced this issue Dec 21, 2021
vinci1it2000 added a commit that referenced this issue Dec 21, 2021
…TE`, `CUMIPMT`, and `NPER` functions.
@vinci1it2000 vinci1it2000 added this to the Alicudi Release milestone Dec 22, 2021
vinci1it2000 added a commit that referenced this issue Dec 23, 2021
@vinci1it2000
Copy link
Owner

>>> import formulas 
>>> func = formulas.Parser().ast('=MEDIAN(A1,A2,A3,A4)')[1].compile()
>>> func(1, 2, 3, 4)
2.5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants