In the formulate below, I would like to include all dimension values EXCEPT ones that contain Class "transfer". However, I can't find the right formula. If I add"<> transfer", I receive an error. Thanks!
That did not work. It essentially excluded everything. In the array that i'm working with, the class field is either " " (blank) or "transfer". Do you have a couple minutes to hop on a call tomorrow?
0 Votes
N
Nathan Gayeskiposted
16 days ago
Thank you Harry! I believe that worked. Testing now and will follow up if I am not getting the results I had expected.
0 Votes
H
Harry Lewisposted
16 days ago
Admin
Nathan -
What you are trying to say is that you want everything except TRANSFER.
0 Votes
Hello,
In the formulate below, I would like to include all dimension values EXCEPT ones that contain Class "transfer". However, I can't find the right formula. If I add"<> transfer", I receive an error. Thanks!
=SI.TURNOVER(Connection,,Q$6,ITD_Start_Date,End_Date,Entity_Main,Books,SI.DIMENSIONS(Connection,"CUSTOMER",$B8,"CLASS","transfer"))
0 Votes
3 Comments
Nathan Gayeski posted 15 days ago
Hello Harry,
That did not work. It essentially excluded everything. In the array that i'm working with, the class field is either " " (blank) or "transfer". Do you have a couple minutes to hop on a call tomorrow?
0 Votes
Nathan Gayeski posted 16 days ago
Thank you Harry! I believe that worked. Testing now and will follow up if I am not getting the results I had expected.
0 Votes
Harry Lewis posted 16 days ago Admin
Nathan -
What you are trying to say is that you want everything except TRANSFER.
Let's try using the syntax as listed here: Filtering techniques for use with many Velixo functions : Velixo Help Center
What happens if you use this version?
=SI.TURNOVER(Connection,,Q$6,ITD_Start_Date,End_Date,Entity_Main,Books,SI.DIMENSIONS(Connection,"CUSTOMER",$B8,"CLASS","*;-transfer"))
0 Votes
Login or Sign up to post a comment