Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following question: In my model I have a field with the Customer_ID and generating the following expression I can make an account Of customers that have a sale greater than an "X".
= COUNT ({<CustomerID = { "= Sum (Sale)> X"}>} DISTINCT CustomerID)
My question is if I can apply this criterion to the whole cloud and not just to a specific object (Table or graph).
Thank you.
Yes it is, you can create an action for the button so the action is Select in Field "Customer" (for example) and Value is set to "=Only(If(Aggr(NODISTINCT Sum(Sales), Customer) > 50000, Sales))" to return values with the given sum.
The expression is a bit more complex for a button if you want it to be several values:
='(' & Concat(If(Aggr(Sum(Expression1), Dim1) > 50000, Dim1), '|') & ')'
Miguel
maybe in a listbox with CustomerID, type (search)
=Sum(Sale) > X
and then enter
Thanks, but the idea would be to apply this on all data and not on a specific table.
If you can help me it would be great!
Is possible to associate the sales filter (=Sum(Sale) > X ) with a button? Or a field created as inline ??
Thank you!
Yes it is, you can create an action for the button so the action is Select in Field "Customer" (for example) and Value is set to "=Only(If(Aggr(NODISTINCT Sum(Sales), Customer) > 50000, Sales))" to return values with the given sum.
The expression is a bit more complex for a button if you want it to be several values:
='(' & Concat(If(Aggr(Sum(Expression1), Dim1) > 50000, Dim1), '|') & ')'
Miguel
Thanks Miguel !!
Work perfectly!