LinkedIn
Twitter
Hi Guys !
I have a problem with a report that generates PDF at night, it is a summary of the business activity.
In general, the report reads the [CORREO] accounts of each of the stores from a table, and for each store [User] generates a summary.
after doing many tests, I came to this conclusion …
FORMULA 1 (PHOTO 1)
SUM (SELECT (MTTO [Cost Parts], AND ([MONTH] = MONTH (TODAY ()), [User] = [_ thisrow]. [BRANCH], [YEAR] = YEAR (TODAY ()))))
indeed in the table [MTTO] there is no “SUCURSAL” field, but in the virtual field the “EXPRESSION ASSISTANT” works fine and gives me the correct values …
however, testing it in “TEMPLATE” (PHOTO 3) of the report gives the following error!
Expression 'SUM (SELECT (MTTO [Cost Parts], AND ([MONTH] = MONTH (TODAY ()), [User] = [_ thisrow]. [BRANCH], [YEAR] = YEAR (TODAY ())))) ‘is invalid due to: Error in expression’ [_THISUSER]. [SUCURSAL] ‘: Unable to find column’ SUCURSAL '.
FORMULA 2 (PHOTO 2)
SUM (SELECT (MTTO [Cost Parts], AND ([MONTH] = MONTH (TODAY ()), [User] = [_ thisrow]. [BRANCH], [YEAR] = YEAR (TODAY ()))))
In “EXPRESSION ASSISTANT” it does not work, it results in ZERO in everything.
putting it in the “TEMPLATE” (PHOTO 4) of the report also makes the calculations wrong, ZERO
I AM CONFUSED AND TIRED, PLEASE A LITTLE HELP …
HOW IT SHOULD BE THE CORRECT FORMULA THAT FUNCTIONS IN BOTH PARTS !!
