Skip to main content
Solved

Roll Up Min(Value) with a filter

  • May 1, 2023
  • 3 replies
  • 26 views

Jason_Jakarta
Forum|alt.badge.img+10

Hi,

 

I'm looking for some help with a rollup that is rolling up start dates and returning the earliest date from a table. 

The aggregate function seen on the image is not taking into account the filter I'm trying to apply. I'm trying to return the earliest date on a roll up where the Session Name is not Session Zero.

 

I do I do this in the formula ?

 

 

Best answer by TheTimeSavingCo

Hi, 

 

Thanks for your response. I recreated the field and it all worked OK. I'm not sure if I hit a bug but I couldn't replicate it. 

Just to be sure, I assume the aggregate formula is supposed to allow for the filtered criteria when applied? 

 

Cheers 

 


Hmm, the values that get used by the formula will be result of the filter criteria you've set if that's what you're asking?

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Could you provide screenshots of the relevant tables and an example of what you'd like to see?


Jason_Jakarta
Forum|alt.badge.img+10
  • Author
  • Known Participant
  • 34 replies
  • May 5, 2023

Could you provide screenshots of the relevant tables and an example of what you'd like to see?


Hi, 

 

Thanks for your response. I recreated the field and it all worked OK. I'm not sure if I hit a bug but I couldn't replicate it. 

Just to be sure, I assume the aggregate formula is supposed to allow for the filtered criteria when applied? 

 

Cheers 

 


TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6410 replies
  • Answer
  • May 5, 2023

Hi, 

 

Thanks for your response. I recreated the field and it all worked OK. I'm not sure if I hit a bug but I couldn't replicate it. 

Just to be sure, I assume the aggregate formula is supposed to allow for the filtered criteria when applied? 

 

Cheers 

 


Hmm, the values that get used by the formula will be result of the filter criteria you've set if that's what you're asking?