AnsweredAssumed Answered

Calculation Help -- need to eliminate blank fields from list.

Question asked by Melinda on Mar 30, 2010
Latest reply on Apr 1, 2010 by Melinda

Title

Calculation Help -- need to eliminate blank fields from list.

Post

Beginner

Mac OS X

FM Pro 9 on a shared server

 

I have written a VERY simple calculation that finds exactly the information I need:

 

If ( Days Billable  >  "0"  ; List ( Date ))

 

HOWEVER, it presents blank fields in the list if the "Days Billable" field is equal to zero.  I want to eliminate those. 

 

If it helps to know, the layout is in list view, and I search by employee between a specified date range.  All I need to know (for now) is the dates of all biilable work within the specified date range.

 

As always, let me know if I need to clarify something, and thanks for your thoughts!

 

Melinda

Outcomes