Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

Help with Ageing formulae

I have created a formulae which I know does not work

if isnull ({WO.SCHEDSTARTDATE}) then 'No Shed Date' else
if ({WO.SCHEDSTARTDATE}) < currentMonth then 'Future Months Requirement' else
if ({WO.SCHEDSTARTDATE}) in currentmonth then 'Due this Month' else
if ({WO.SCHEDSTARTDATE}) in LastFullMonth then 'Due Last Month' else

Can someone correct the above for me
Gordon
0
Gordon Hughes
Asked:
Gordon Hughes
  • 4
  • 3
  • 2
2 Solutions
 
mlmccCommented:
For a future requirement the Scheduled Start Date would be GREATER THAN today.

if isnull ({WO.SCHEDSTARTDATE}) then 'No Shed Date' else
if ({WO.SCHEDSTARTDATE}) in currentmonth then 'Due this Month' else
if ({WO.SCHEDSTARTDATE}) in LastFullMonth then 'Due Last Month' else
if ({WO.SCHEDSTARTDATE}) > currentMonth then 'Future Months Requirement' else

What isn't working?

mlmcc
0
 
peter57rCommented:
if isnull ({WO.SCHEDSTARTDATE}) then 'No Shed Date'
else
if {WO.SCHEDSTARTDATE} > dateserial(year(currentdate), month(currentdate)+1,0)then 'Future Months Requirement'
else
if {WO.SCHEDSTARTDATE} >= dateserial(year(currentdate), month(currentdate),1) then 'Due this Month'
 else
if {WO.SCHEDSTARTDATE} in LastFullMonth then 'Due Last Month'
else
"Before Last Month"
0
 
Gordon HughesDirectorAuthor Commented:
Hi mimcc/peter67r

Good to hear from you
I think the solution peter has given me works
How can i make the report order the heading
No Shed Date
Future Months Requirement
Due This Month
Older than last month

Rather than in alpha order
Gordon
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
peter57rCommented:
If you are grouping on this field then you can use the 'Specific Order' option in the Group dialog to set the group order.

Or you could just prefix the text with a letter to force a sequence..

A. No Shed Date
B. Future Months Requirement
C. Due This Month
D. Due Last Month
E. Older than last month
0
 
Gordon HughesDirectorAuthor Commented:
Hi Peter57r
Where do I find the Group dialog so that i can specify the order?

Gordon
0
 
mlmccCommented:
Right click on the group header in the left margin
Click CHANGE GROUP
Click the dropdown on order
Choose SPECIFIED ORDER
A new tan will appear and you can specify the order

mlmcc
0
 
Gordon HughesDirectorAuthor Commented:
Hi mimcc
The information is presented in a cross tab which is in a sub-report
so the cross tab is currently shown in the report header of the sub report
hope this makes sense, so I currently do have a Change group option
Any suggestions

Gordon
0
 
mlmccCommented:
You can do the same thing in the cross tab

Edit the subreport
Right click the cross tab in the upper left corner
Click CROSS TAB Expert
Select the field in the row or column block
Click CHANGE GROUP
Set the order to SPECIFIED ORDER

mlmcc
0
 
Gordon HughesDirectorAuthor Commented:
Always excellent from mimcc and peter57r
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now