Skip to Content
0
Former Member
Dec 22, 2006 at 04:19 PM

Periods Vaule question (Actual & YTD)

11 Views

Good Morning Everybody

In a given query, i need two dates in order to show the proper information. (actual and YTD)

this is a sample on what we have now.

Current" target="_blank">http://img218.imageshack.us/img218/916/sinttulo1vu1.jpg">Current Scenario

What we would like to know, is if theres a way to avoid the Fiscal Period (Actual) value, since its and it will always be the same vale as the end date of Fiscal Period YDT

This is a Sample on what we are trying to do.

Expected" target="_blank">http://img228.imageshack.us/img228/9140/qry2de9.jpg">Expected Scenario

Thanks in Advance.