IFERROR(;0)
Maybe they should use a more appropriate development tool for their critical security platform than Excel.
Comment on CrowdStrike downtime apparently caused by update that replaced a file with 42kb of zeroes
driving_crooner@lemmy.eco.br 3 months agoThe file is used to store values to use as denominators on some divisions down the process. Being all zeros is caused a division by zero erro. Pretty rookie mistake, you should do IFERROR(;0) when using divisions to avoid thay.
IFERROR(;0)
Maybe they should use a more appropriate development tool for their critical security platform than Excel.
sugar_in_your_tea@sh.itjust.works 3 months ago
I disagree. I’d rather things crash than silently succeed or change the computation. They should have done better input and output validation, and gracefully fail into a recoverable state that sends a message to an admin to correct. A divide by zero doesn’t crash a system, it’s a recoverable error they should 100% detect and handle, hot sweep under the rug.
driving_crooner@lemmy.eco.br 3 months ago
Life pro tip: if you’re a python programmer you should use try: func() except: continue every time you run a function, that way ypu would never have errors on your code.
sugar_in_your_tea@sh.itjust.works 3 months ago
Lol.
CeeBee_Eh@lemmy.world 3 months ago
🤔