User Responce using in Relative date function

building reports webintelligence
1

Helllo All ,

I need to sum the Revenue for the user parameter date and Pervious year for same month

i created a query filter type promt on field posting date less than or equal then

I created a Variable : Date1 = FormatDate(ToDate(UserResponse([Query 1];“Enter Start Date (PER):”);"");“MM/dd/yyyy”)

Created Variable : Date 2 to get the same date but pervious year …

How can i cum Revenue in respective to the two fields to have two columns for example 2019 | 2020

zahmed (BOB member since 2018-01-14)

2

you can do this with a if-condition within one variable:

something like:
if date = date1 than ‘this_year’ else if date = date2 then ‘previous_year’
–> so you can set or filter your columns on the text-content of that variable

or you can do this with two variables:

something like:
rev_this_year: if date = date1 than [revenue]
rev_prev_year: if date = date2 than [revenue]
–> so you can insert these variables directly into your columns

n8aktiv :de: (BOB member since 2018-12-29)