Hi,
I want to ask, I have a data table like this:
Date Field 1 Field 2
1/1/2019 AA 2000
1/1/2019 BB 3000
**rate charge for AA=AA multiply with 34
rate charge for BB=BB multiply with 28.8
I already did this expression:
max (if((field 1= 'AA' or field 1= 'BB') and weekday(date)<> 'Sat' and weekday(date)<>'Sun', [field 2]))
then, I want to multiply that AA and BB with the their rate charge.
Thank you in advance!