Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to count the month end numbers of a field AIF where AIF in P and A but it's not working using below code, Can any one please help
count(if(LoadDate_Active=monthend(LoadDate_Active), {$<AIF = {"P"}> + $<AIF = {"A"}>} AIF))
Regards,
Shumail Hussain
Shumail,
Try first the form without set analysis:
count(if(LoadDate_Active=monthend(LoadDate_Active) and (AIF='P' or AIF='A'), AIF))
If it works, and you still want to use set analysis, try to change it to:
count({$<AIF={"P","A"}>} if(LoadDate_Active=monthend(LoadDate_Active),AIF))
Shumail,
Try first the form without set analysis:
count(if(LoadDate_Active=monthend(LoadDate_Active) and (AIF='P' or AIF='A'), AIF))
If it works, and you still want to use set analysis, try to change it to:
count({$<AIF={"P","A"}>} if(LoadDate_Active=monthend(LoadDate_Active),AIF))
Hi Michael,
I tried but both of the code are not working...
Regards
Shumail
No working means, it's showing no value as i know there's a value. As per the code it looks fine and ok. I tried it through typecasting but my system got hanged everytime..
=count(if(Date(LoadDate_Active, "DDMMYY")=Monthend(Date(LoadDate_Active, "DDMMYY")) and (AIF='P' or AIF='A'), AIF))
below is the message which appears:
Now I have tried the below code which is working fine and my system not going hanged.
=count(if(day(LoadDate_Active)=day(Monthend(LoadDate_Active)) and (AIF='P' or AIF='A'), AIF))
I see - when you define format, it must be in single quotes: date(LoadDate_Active, 'DDMMYY').
Be careful with day() function, it is unique only within one month.
Yes Michael, but it's surves my purpose as the project file is a daily one only and will be new for each months so i am not worried about it.
Regards
Shumail Hussain