cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aadams13 Frequent Visitor
Frequent Visitor

INVENTORY aCCURACY FOR LAST 14 DAYS

I am attempting to generate an Inventory Accuracy Percentage but is getting a Syntax Error Message.

 

WEEK ACCURACY = CALCULATE(COUNTROWS(Cycle_Count_Accuracy_Report[ADDDATE]Cycle_Count_Accuracy_Report[VARIANCES]="NOVARIANCE"),COUNTROWS(Cycle_Count_Accuracy_Report),0),FILTER('DATE',DATESBETWEEN('DATE'[Date],TODAY(),TODAY()-14)))
 
This the formula i am attempting to use.
4 REPLIES 4
aadams13 Frequent Visitor
Frequent Visitor

Inventory Accuracy Formula

I am attempting to generate an Inventory Accuracy Percentage but is getting a Syntax Error Message.

 

WEEK ACCURACY = CALCULATE(COUNTROWS(Cycle_Count_Accuracy_Report[ADDDATE]Cycle_Count_Accuracy_Report[VARIANCES]="NOVARIANCE"),COUNTROWS(Cycle_Count_Accuracy_Report),0),FILTER('DATE',DATESBETWEEN('DATE'[Date],TODAY(),TODAY()-14)))
 
This the formula i am attempting to use.
Community Support Team
Community Support Team

Re: Inventory Accuracy Formula

Hi @aadams13 ,

 

AFAIK, count rows not contains any optional parameter allow you to add filters. If you wanted to count the filtered table rows, please package then with filter function first.

 

Sample:

WEEK ACCURACY =
CALCULATE (
    COUNTROWS (
        FILTER (
            ALLSELECTED ( Cycle_Count_Accuracy_Report ),
            Cycle_Count_Accuracy_Report[VARIANCES] = "NOVARIANCE"
        )
    ),
    FILTER ( 'DATE', DATESBETWEEN ( 'DATE'[Date], TODAY (), TODAY () - 14 ) )
)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
aadams13 Frequent Visitor
Frequent Visitor

Re: Inventory Accuracy Formula

It is still not wokring for me

Community Support Team
Community Support Team

Re: Inventory Accuracy Formula

HI @aadams13 ,

 

Please share more details informations to help us clarify your scenario.

How to Get Your Question Answered Quickly

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,777)