system
#1
Hi
I am having difficulty solving this one!
I need a formula that basically does this:
=<Amount(JournalsLY)> Where (<PERIOD(JournalsLY)>=“12-09”)
However I want to replace the “12-09” with a UserResponse:
=<Amount(JournalsLY)> Where (<PERIOD(JournalsLY)>=UserResponse (“CM” , “Enter period end last year (MM-YY)”))
This should give the same result but I am getting “Syntax Error”
Any ideas?
sh1pley (BOB member since 2009-06-03)
system
#2
Use If() instead of Where()
The reason is Where does accept only a constant as the right hand side operand.
Jansi (BOB member since 2008-05-12)
system
#3
I then get a COMPUTATION error
The JournalsLY provider has multiple Periods of data in there so I just need the data(Amounts) where it matches the UserResponse
sh1pley (BOB member since 2009-06-03)
system
#4
Check this FAQ.
Jansi (BOB member since 2008-05-12)
system
#5
Try:-
Sum(If(<PERIOD(JournalsLY)>=UserResponse ("CM" , "Enter period end last year (MM-YY)"));<Amount(JournalsLY)>)
Mak 1 (BOB member since 2005-01-06)