Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an equation:
=RangeSum(Above(Sum{$<PRICE >{"0.00"},}>}(QTY),0,RowNo()))
with which I am trying to get the aggregating QTY of tickets where the price is greater than 0.00. I cannot get the editor to accept the structure of my equation. Looking for suggestions on how to correct.
maybe soemthing like this?
RangeSum(Above(Sum(
{< PRICE ={">0.00"}>}QTY
),0,RowNo()))
Try this
=RangeSum(Above(Sum{$<PRICE = {">0.00"}>} QTY), 0, RowNo()))
maybe soemthing like this?
RangeSum(Above(Sum(
{< PRICE ={">0.00"}>}QTY
),0,RowNo()))