How to Format a Summary of a Table for posting to Slack

2

Hi @Thomas_Robbs1 ,

Maybe this could help:

[My Table].Name.Unique().
  FormulaMap(CurrentValue.WithName(name, 
    Format("{1}: {2}", 
      name, 
      [My Table].Filter(Name=name).Value.Sum()
      )
    )
  ).BulletedList()

A simplified version, without WithName(), here unnecessary, even though I tend to use it anyway:

[My Table].Name.Unique().
  FormulaMap(
    Format("{1}: {2}", 
      CurrentValue, 
      [My Table].Filter(Name=CurrentValue).Value.Sum()
    )
  ).BulletedList()

Let me know if you have further questions.
Cheers!

3 Likes