Forum Discussion
Solved
Formula not working - Dynamic array for subtraction
Currently I'm facing a error with the below formulas, which is giving Error "You have entered too many Argument for this function" or simply "Zero" is coming as output. Hence requesting any SME suppo...
looks like you have lots of ZERO values that I'm guessing you want to ignore also? Maybe try:
=IFERROR(LET(range, BD3:BO3, filled, FILTER(range, range<>0), last, TAKE(filled, , -1), previous, TAKE(DROP(filled, , -1), , -1), IF(last=previous, last, previous-last)), "")
looks like you have lots of ZERO values that I'm guessing you want to ignore also? Maybe try:
=IFERROR(LET(range, BD3:BO3, filled, FILTER(range, range<>0), last, TAKE(filled, , -1), previous, TAKE(DROP(filled, , -1), , -1), IF(last=previous, last, previous-last)), "")
