Show Invoice URL Link and Amount for Records Between Dates
I'm building a table that pulls the Amounts and Invoices for records between two dates based on their Service Date. However, if I get the correct rows pulled the Invoice Links don't show. If I get the Invoice Links to show all the records for the particular Vendor are pulled with the Amounts outside the Date Range as zeros. What's the Invoice Link code that will show only those invoices during that timeframe?
Thanks,
Mindy
Attempt #1
Date Range = 4/1/13 - 7/1/13
Expressions:
Invoice Link =if({$<[Service_Date]={'>=$(vStartDate) <=$(vEndDate)'}>}[Invoice_No] & '<url>' & [Invoice_Link])