Skip to main content

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

 

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

 

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!

thanks everyone for the response.

Reply


Ask your question here!

Terms & ConditionsCookie settings