I am trying to return a 0 if a whole operation is blank, its long enough to copy and paste it again in the false value, any alternatives?
You can use WithName() to give a name to a bunch of formula code.
Somecomplicatedstuff().blabla.etc().WithName( MyStuff, If( MyStuff.isBlank(), 0, MyStuff ) )
This takes your complicated code, gives it the name “MyStuff”, and then you can use MyStuff to reference that result in multiple places.
thanks! I managed to do th formula
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.