I'm trying to build a formula to multiply a random number by x if the time in another field is after 12PM, and by y if the time is before 12PM. Right now here is what I have:
if field("Start Time") > "12:00:00 PM" THEN random(1,24) * 1.3
elseif field("Start Time") <= "12:00:00 PM" THEN random(1,24) * .7
however, I'm getting a syntax error and cannot figure it out. Help please!