Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Have 2 tables linked with one column
Invoice
fam_num
residence_ num_invoice
Residence
fam_num
residence_num
I am trying to make a chart where the residence_num_invoice = residence num
The expression I am using is given below:
sum({<[RESIDENCE_NUM_INVOICE]=[RESIDENCE_NUM]>}ENTREE)
But I get Result = 0
When I am replace RESIDENCE_NUM by a number that exists, all is right
sum({<[RESIDENCE_NUM_INVOICE]={4117}>}ENTREE) for example
What's the problem in the first expression ?
Any help would be greatly appreciated.
sum({$<residence_num_invoice = P({$} residence_num)>} entree)
hi,
maybe something like this might help:
Sum(If(RESIDENCE_NUM_INVOICE = RESIDENCE_NUM, ENTREE, 0))
Thanks
That's work but I don't understand why it dosn't work with the the expression
sum({<[RESIDENCE_NUM_INVOICE]=[RESIDENCE_NUM]>}ENTREE)
sum({$<residence_num_invoice = P({$} residence_num)>} entree)