Hi everyone!!
I’m trying to get diferent averages depending on the dropdown value. Currently my formula is:
IF({Bundle Type}=“Pack Original”,AVERAGE({GM % 1},{GM % 2},{GM % 3},{GM % 4},{GM % 5},{GM % 6}),IF(OR({Bundle Type}=“Boxbed + Hybrid”,{Bundle Type}=“Boxbed + Original”),AVERAGE({GM % 1},{GM % 2}),0))
What happens is it calculates the first condition but the second it says “One of the parameters is invalid”.
Can someone help me with this error? Thank you!!