I am working on the creation of an email change template, with this fourmula but โฆ
Total Cards: << SUM (SELECT (DETAIL NOTE [CTD], [ARTICLE ID] = << [NOM EXGDE] >>)) >>
in this formula I want to obtain the sum of [CTD] in the table โNOTE DETAILโ, when the field โARTICLE IDโ is equal to the value of << [NOM EXGDE] >>, but the email is not generated and says that there is an error in the formula
Can the substitution of [NOM EXGDE] be done? Or itโs just a syntax error โฆ
โNumber of opened and closed parentheses does not matchโ
Can you help me?
You should probably use something likeโฆ
Total Cards: << SUM(SELECT(DETAIL NOTE[CTD],[ARTICLE ID]=[NOM EXGDE])) >>
Yeessssโฆ , i am little lost, thxโฆ
that formula brings me the total record, but i need only thouse that check my key, i add [LLAVE ID] = [_THISROW], and bring me cerro ! wath is wrong ? <<SUM(SELECT(DETAIL NOTE[CTD],and [ARTICLE ID]=[NOM EXGDE], [LLAVE ID] = [_THISROW]))) >>
SUM(SELECT(DETAIL NOTE[CTD],and([ARTICLE ID]=[NOM EXGDE],[LLAVE ID] = [_THISROW].[LLAVE ID]))) if the column name is LLAVE ID in both tables.
Thats the
solution my friend ! many thx !!!
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |