Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to know if it is possible to use a set analysis restriction in a text object but without any expression.
In another words: usually the set analysis is made with a expression like: count, max, aggr, sum, etc and the respective restrictions.
I want to use a set analysis without the expression because I want to show a string and not a value, but I need the restrictions that a set analysis provides me.
Any thoughts?
Thank you.
Best regards.
Ivo Marques
No, but you can use a search string e.g.
Sum({<Customer={"=Mid(Customer,1,1)='A'"}>} Sales)
in your example
=maxstring({<TestArea={'ASD'},KNR={"=mid(KNR,3,1)='7'"},Description-={'Not valid values:'},Results-={'0'}>} Description)