Trouble with Set Analysis

[#1]

I am trying to sum the total of parts cost * Qty on hand if the part has not had any movement in Sales_8_Months AND has not been received in the last 8 months. I have the set analysis statement I have been working with and it works on most of the part number but not this one. Any help would be much appreciated.

Sum({$<Sales_8_Months={"<=0"},PART_RECEIVED_MMonth={"<=$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-8),'MMM-YY'))"}>}[Part cost - PMPCST]*[Quantity on hand - PMQONH])

[#2]

Correction. It is now calculating but when I click on the part number in straight table the amount disappears.

[amayuresh]

please provide sample data.

[#4]

My set analysis is working if I do not select the part number. When I select the part number to show only that part number the set analysis No Movement 9 Months zeros out.

Here is where the No Movement 8 Months is showing correctly.

Here is when I select 5161419 part number it zeros out.

Here is the set analysis expression I am using.

=Sum({$<Sales_8_Months={"0"},PART_RECEIVED_MMonth={"<=$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-9),'MMM-YY'))"}>}[Part cost - PMPCST]*[Quantity on hand - PMQONH])

Thank you

[sunny_talwar]

Not 100% certain, but can you try this:

=Sum({$<Sales_8_Months={"0"},PART_RECEIVED_MMonth={"<=$(=Date(AddMonths(Max({<[Part #]>}PART_RECEIVED_MMonth),-9),'MMM-YY'))"}>}[Part cost - PMPCST]*[Quantity on hand - PMQONH])