Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I cannot get this bad boy to work team.
What have I done wrong...
=
Count(if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-
2
)), ({<[iDesignOR Status]{'Processed','Order'}>}[iDesignOR Status]) ))
It worked (see below) until I added the last criteria to only count the Processed and Order options
=
Count(if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-
2
)), [iDesignOR Status]))
Try
Count({<[iDesignOR Status]={'Processed','Order'}>} if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-2)), [iDesignOR Status]))
Try
Count({<[iDesignOR Status]={'Processed','Order'}>} if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-2)), [iDesignOR Status]))
Top Man!