Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a table with two columns,Carrier and Sales. Carrier Field has two types of value one record for PRODUCE and one for DRY.
The issue is to show sum(sales) in a text object. But whenever a Produce carrier field is selected it sum(sales) for all PRODUCE field
the same with DRY field.
I have attached application and xls file.Please if anyone has any idea please share with me.
Thanks and Regards
bhawna
Try
If(Match(SubField(CARRIER,'-',2),'PRODUCE'),Sum({<CARRIER={'*PRODUCE*'}>} Sales),
If(Match(SubField(CARRIER,'-',2),'DRY'),Sum({<CARRIER={'*DRY*'}>} Sales)))
Regards
Use this in your Text Box and it worked
if(if(match(SubField(CARRIER,'-',2),'PRODUCE'),Sum(Sales))>0,if(match(SubField(CARRIER,'-',2),'PRODUCE'),Sum(Sales)),if(match(SubField(CARRIER,'-',2),'DRY'),Sum(Sales)))
Try
If(Match(SubField(CARRIER,'-',2),'PRODUCE'),Sum({<CARRIER={'*PRODUCE*'}>} Sales),
If(Match(SubField(CARRIER,'-',2),'DRY'),Sum({<CARRIER={'*DRY*'}>} Sales)))
Regards
Thank you Antonio..