Skip to main content
Question

Previous Function with Multiplication

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

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
    Community Manager
    Forum|alt.badge.img+16
    • 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+4
    • LouieAuthor
    • Author
    • Author
    • October 24, 2024

    thanks everyone for the response.

      Ask your question here!

      Terms & ConditionsAccessibility statement