Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that counts the number of 'buys' in one column and the number of 'sells' in another column. Is it possible to add a third column that shows where there are both buys and sells?
Count({<Side={'Buy'}>}Side)
=Count({<Side={'Sell'}>}Side)
Thanks,
Daniel
May be like this
=If(Count({<Side={'Buy'}>}Side) > 0 and Count({<Side={'Sell'}>}Side), 'Both Buy and Sell')