Skip to main content
Question

Previous Function with Multiplication

  • October 18, 2024
  • 3 replies
  • 118 views
Louie
Author
Forum|alt.badge.img+6

Hi Pigmenters,

Any suggestions on how to write a more elegant formula to achieve the results shown in the Excel please.

Here s the current solution: ifblank(ifblank(Metric, 1)*previous(Month), Metric)

 

Thanks,

 

Louie

 

3 replies

Lehtohen
Master Trendsetter
Forum|alt.badge.img+2
  • LehtohenMaster Trendsetter
  • Master Trendsetter
  • October 23, 2024

Hey, 
No sure if this is more elegant or not :D 

 

Lehtohen
Benoit
CDALMAY
Issam Moalla
Benoit
Community Manager
Forum|alt.badge.img+15
  • BenoitCommunity Manager
  • Community Manager
  • October 23, 2024

Hi, thanks a lot @Lehtohen for this alternative! I don’t have any better option in mind.

Just wanted to give a insight about performance. Even though the IFDEFINED formula doesn’t necessarily looks “more elegant”, it is slightly more performant, especially if you work wih high cardinalities as the calculation will run over defined cells rather than blank cells.

Enjoy!

Benoit - Pigment wizard
Louie
Author
Forum|alt.badge.img+6
  • LouieAuthor
  • Author
  • Author
  • October 24, 2024

thanks everyone for the response.

Benoit

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement