Formula problem

[#1]

Hi all

Can somebody explain why this formula is not working?

=sum({$ < Fakten.Kostenart = {4207, if(vDatumVon <= '31.03.2012', '6662',Null)}, Kalender_Datum = {"$(='<='&(vDatumBis)&'>='&(vDatumVon))"}  >} Fakten.Betrag )

When I replace "if(vDatumVon <= '31.03.2012', '6662',Null)" with a variable "vtest" it works perfectly.

sum({$ < Fakten.Kostenart = {4207, vtest}, Kalender_Datum = {"$(='<='&(vDatumBis)&'>='&(vDatumVon))"}  >} Fakten.Betrag )

I've no idea why?

cheers

Marco

[#2 · Accepted solution]

Hi,

you can not use expressions directly in set anlysis.

so use:

$(=if(vDatumVon <= '31.03.2012', '6662',Null))

for

"if(vDatumVon <= '31.03.2012', '6662',Null)"

hope it helps u.

Niranjan M.

[#3]

Cool, works perfectly. Thank you. You made my day