Skip to main content
Solved

Select Total Aggregator

  • February 9, 2025
  • 2 replies
  • 80 views

Hello, 

I have a metric “MD02 - Quel macro composant ?” which displays elements from the list “macro composant” and its total. The dimensions are “Composants” and “macro composants”.
 

 

I also have a second metric where I want to display the total with the only dimension “Composants” : 

 


Do you know which formula I must use in this second metric please ?

Thank you very much !

Best answer by oliverlee

@msouss is your Total the first non blank or last non blank?

You’d use the same aggregator in your formula, i.e.

'MD02 - Quel macro composant ?'[REMOVE FIRSTNONBLANK: 'macro composant']

or

'MD02 - Quel macro composant ?'[REMOVE LASTNONBLANK: 'macro composant']

2 replies

oliverlee
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • Answer
  • February 10, 2025

@msouss is your Total the first non blank or last non blank?

You’d use the same aggregator in your formula, i.e.

'MD02 - Quel macro composant ?'[REMOVE FIRSTNONBLANK: 'macro composant']

or

'MD02 - Quel macro composant ?'[REMOVE LASTNONBLANK: 'macro composant']


  • Author
  • Apprentice Author
  • February 10, 2025

@oliverlee it was last non blank and the formula worked perfectly, thank you very much !!