Forum Discussion

rh203's avatar
rh203
Icon for Helper I rankHelper I
5 years ago
Solved

Calculated Column: Sum of another column from same table based on criteria

Hi,   I am trying to sum a value in a table to create a pallet projection based on a starting stock position, inbound and outbound volume.   All of this data is within the same table but when I t...
  • HotChilli's avatar
    HotChilli
    5 years ago

    OK, you're on your way.

    You could improve it by amalgamating the two FILTER clauses into one.

     

    FILTER(Pallet_projection, Pallet_projection[dateke...] = 0  && Pallet_projection[factor...] = EARLIER Pallet_projection[factor...]

     

     

    I've just shortened my typing with .......

rh203's avatar
rh203
Icon for Helper I rankHelper I
5 years ago

Hi, Thanks for the reply - yes sorry I had to redact for obvious reasons.

 

I worked out the solution in the last 15 mins - see below.

 

Looks like 'EARLIER' is key to pick up the current row as the criteria for a filter within the CALCULATE function.

 

It's done the job.

 

Thanks for your help 

 

 

 

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

OK, you're on your way.

You could improve it by amalgamating the two FILTER clauses into one.

 

FILTER(Pallet_projection, Pallet_projection[dateke...] = 0  && Pallet_projection[factor...] = EARLIER Pallet_projection[factor...]

 

 

I've just shortened my typing with .......