Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

What is wrong with this formula?

Kata Soltesz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 29, 2018

I would like to calculate all issues that either due compared to the Requested Delivery Date or doesnt have a date:

COUNT([Measures].[Issues created]-([Measures].[Issue Requested Delivery Date]<Now()))

I get the following error message:

Formula is not valid: 
No function matches signature '<Member> < <DateTime>'

 

Thanks for the help!

 

1 answer

0 votes
Grigory Salnikov
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 29, 2018

Hi, @Kata Soltesz and welcome to the Community!

I assume that your project's name is "Measures", correct me if I'm wrong.

I'd write something like this:

project = Measures AND ( "Issue Requested Delivery Date" < now() OR "Issue Requested Delivery Date" is EMPTY )

 

Suggest an answer

Log in or Sign up to answer