Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Please find the below data ,
For this data i want the expression for it will tell how many Prdoucts have a value for this selected period.
Year | Product | sales |
---|---|---|
2016 | a | 10 |
2016 | b | - |
2017 | a | 100 |
2016 | b | |
2015 | a | 110 |
2015 | b | 120 |
2015 | c | - |
2014 | c | 20 |
2014 | a | - |
May be this?
Count({<sales -= {'-',''}>} sales)
Hello,
Can you show your final required output screen.
count(<sales-={'-',''}>product)
or
count(if(not wildmatch(trim(sales),'-',''),product))
Regards,
Test done