Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can some one help me to modify below script. From the script I able to getresult for 'Disbursement' within range for past 12 mths.
Count({$<[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')
&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))"}>} if(Product='AFFSTR0001', [FS: Account]))
Result:
My Issue:
Now, I wish to have a record with single 'DISBURSED MONTH' only. Therefore I already do the modification by using below script but the result is not the same as earlier script :
Count({$<[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')
&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))"}>}
{$<DISBURSED MONTH={'$(=max(DISBURSED MONTH))'}>} if(Product='AFFSTR0001', [FS: Account]))
Please help me. I believe I miss out some important command in the script that make the total become different with more records.
Regards.
It's difficult to explain and troubleshoot. Would you provide the sample
Try a luck
Count({$<[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')
&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))", [DISBURSED MONTH]={'$(=max([DISBURSED MONTH]))'}}>}
if(Product='AFFSTR0001', [FS: Account]))
input [] around field name also, i don't think that you need to have below part
[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')
&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))",