Forum Discussion

Vaneet05's avatar
Vaneet05
Helper I
4 years ago
Solved

Values not coming Accurately

Dear All,

https://drive.google.com/file/d/1Dc2Q7fLMsUcDh0-42IBRva8n7erjv2pV/view?usp=sharing 

In my workbook in the last table value for the column, Amount_considered_for_MSP_Variance is not coming out correctly when I removed the Order number from the table. When I kept the order number in this data is coming correctly but I want this data only on Category level but when I removed the order number values are changing the grand total is not the same.

 

Before Removing Order number screenshot below:

After Removing Order Number screenshot below:

 

 

Please help to resolve this issue.

 

 

 

 

Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try using this measure instead:

    Amount_Considered_For_MSP_Variance_W_Ser__ 2023 =
SUMX (
    'Invoice',
    CALCULATE (
        IF (
            [FY-2022-23 Total Target Price] > 0,
            [FY 2022-23 Net Sales Without Service] - [FY-2022-23 Total Target Price]
        ),
        Invoice[Order_Type__c] <> "Replacement"
    )
)

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    Try using this measure instead:

    Amount_Considered_For_MSP_Variance_W_Ser__ 2023 =
SUMX (
    'Invoice',
    CALCULATE (
        IF (
            [FY-2022-23 Total Target Price] > 0,
            [FY 2022-23 Net Sales Without Service] - [FY-2022-23 Total Target Price]
        ),
        Invoice[Order_Type__c] <> "Replacement"
    )
)