Please help - calculation incorrect for backlog

[Deeks]

Hi, 

I am trying to calculate the amount that should be "backlog", so it has not been shipped yet. My current formula adds up everything up to the current week's date. I'd like it to add any amount that is new/backlog, but not shipped. For example, if a sales order has been marked as shipped, it should not be counted in the following week's backlog total. So, mathematically I'd want new+backlog-shipped as a total for each week. I have attached my dataset below. 

BacklogDataset 

[Gengar]

Hi @Deeks ,

Try something like this:

Backlog Amount2 = CALCULATE ( [OverallValue], FILTER('OOR','OOR'[New/Backlog] = "Backlog"&&[isShipped]=FALSE())) + 0

Best regards,

Gengar

[Deeks]

Hi @Gengar 
Thank you for your response, it didn't quite work as I need it to, but I have found a workaround for this now, using original code.