Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i am using this expression to find net sales, where among other criteria, the most important is that the transaction store Number (%transaction__store__ID) equals the Main Store Number (%mainstorenumber__member__ID). The first field is located in the Transactions table, while the second in the customer's table.
=num(
sum({$<transaction_date_numeric = {">=$(=max(member_timestamp_numeric_date)-365)<=$(=max(member_timestamp_numeric_date))"},
%transaction__store__ID = %mainstorenumber__member__ID,, transaction_date_month =, transaction_date_year =, transaction_date_monthyear=, transaction_date_quarter=,
%active__member__ID ={1}, member_NonMember = {'member'}>}transaction_NetSalesinclVAT_EUR),
'#.##0 €')
PROBLEM: i get "zero" when using this expression. It seems it is not working, because when i select values from the list boxes, i get a list of possible values or the same one. Is it possible to equal two table fields from different tables (they are indirectly related) in the set expression? When using "field 1 = p(field 2)" it works. the colors in the set expression appear as they were not correct from the syntaxis, but several times this happens, even if the expression is correct, so i did not pay attention to it.
thanks for any help
Is it possible to equal two table fields from different tables (they are indirectly related) in the set expression?
Only in very specific situations. You need a field that identifies the lowest granularity level. Maybe you have a transaction id that would work. Then you'd use the syntax transaction_id = {'=%transaction__store__ID = %mainstorenumber__member__ID '}
thanks it worked. My question now is:
what do you mean only in very specific situations?