INVENTORY aCCURACY FOR LAST 14 DAYS

Anonymous · ‎02-28-2019

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.

Anonymous · ‎02-27-2019

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.

v-shex-msft · ‎02-28-2019

Hi @Anonymous ,

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
If this post helps, please consider accept as solution to help other members find it more quickly.