Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A



Hi my name is Manuel and i am from Mexico, i hope i could learn a lot about SAP with you guys.

This is my first post in this platform, excuse me if my english is not good enough to have a great fluency and have a good comunication with all you people.

I dont know if i could ask a question but i hope not having any kind of problem

Well, my problem is that i have the following formula

=If(Compare(ReportFilter([Query 2].[Month]);"*;*")=1)

Then [Month Acumulado 2] + " Acumulado "+Right([Query 2].[Year];4)

ElseIf (IsNull(ReportFilter([Consulta 2].[Month])))

Then "No Data "+Right([Query 2].[Year];4)

Else [Mes Individual 2]+" "+Right([Query 2].[Year];4)

This works with an input control but the result is not the expected and i don't know why!, i already check my variable values and it's ok.

When i change the value of input control, the result is fine but when i choose the option "All Values" it takes one month before the one that i want to display.

Instead of display "July Acumulado 2015" shows "June Acumulado 2015"

I almost could bet that is something easy to fix but i can not find it.

Thanks for the help and i hope making friends here.

Former Member
Not what you were looking for? View more on this topic or Ask a question