Operator to Exclude a Dimension Value

Posted about 22 hours ago by Nathan Gayeski

Post a topic

Nathan Gayeski

Un Answered

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

2 Comments

Nathan Gayeski posted about 21 hours 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 about 21 hours 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