invoice for current year

[former_member539471]

HI ,

I have 'Invoice Amt' field . How to create a variable for invoice amt for current year in webi.

Thanks.

[nscheaffer]

Do you have a date associated with your Invoices? If not, include that in your query. Then make a variable to extract the year from that date like this...

=Year([InvoiceDate])

Then put that in your report along your Invoice Amount and filter on the year for the current year.

Noel