Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I've got a Gauge, and I need to have an 'Or' statement evaluated. But for the life of me I can't figure out how to do it. My statement looks like so, and it errors out no matter what:
(
COUNT({<isDelivery={'1'},
OutofGracePeriod={'1'},
([Destination Point] = {'Miami'} or [Origin Point] = {'Charlotte'} )
>}
[Flight Number]
)
Any help on this rookie issue would be greatly appreciated.
Try this
Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Miami'}>+<isDelivery={'1'}, OutofGracePeriod={'1'}, [Origin Point] = {'Charlotte'}>} [Flight Number])
or not sure, but try this as well
Count({<isDelivery={'1'}, OutofGracePeriod={'1'}>*(<[Destination Point] = {'Miami'}>+<[Origin Point] = {'Charlotte'}>)} [Flight Number])
Or maybe?
Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Miami'}>[Flight Number]) +
Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Charlotte'}>[Flight Number])