Hi everyone, I'm new in SAP BO Webi.
I'm working with a simple table that show a job status report with Job, Date of Job and State. I want to show last month activity only, so I make 2 variable:
- Max Pariod: Left(Max([Date]);7) = 2015-11
- Period: Left([Date];7) = 2015-11, 2015-10, 2015-09, etc.
Then in the table I compare those variables, por example:
=if [Period] = [Max Period] then [Job Name]
=if [Period] = [Max Period] then [Date]
=if [Period] = [Max Period] then [State]
But when I do this the error #MULTIVALUE appears. I think the logic is right, but I don't know where I'm making something bad.