hi all, i'm querying a pricing benchmark data set with product level detail from a customer's recent purchases. to help refine things, i'm attempting to keep the low benchmark price within a 3x and 1/3x range of the currently paid price.
so, for instance, if i've been buying Foo at $100, I don't want any results less than $33 or more than $300 in the 'benchmarkLow' field i'm tripping over syntax, i think. i currently have: {!frange l=div(100,3) u=prod(100,3) v='benchmarkLow'} i've also tried it with the benchmarkLow outside the curly: {!frange}benchmarkLow the benchmark field is a double, fwiw. what am i missing here? thanks for any info!