IF expression with multiple conditions

[#1]

Hello everyone,

I need to write a "IF expression" with 4 conditions and I am having troubles.

I have 2 dates: DataMovimento and DataCalendario and thus two calendars.

I would like that: if the user selects a Year/Month/Week/Day of one calendar then the date of the other calendar becomes the same.

The field I need to aggregate is OreDisp (number of hours available)

My try:

if( GetSelectedCount(Date(DataMovimento)) ,  sum( { <DayCalendario = {"=Day(DataMovimento) "}>} OreDisp) ,

                if(GetSelectedCount(Settimana), sum(   {$<SettimanaCalend = {"=Settimana"} >}   OreDisp) ,

          if(GetSelectedCount(Month), sum(   {$<MonthCalendario = {"=Month"}>}   OreDisp) ,

          if(GetSelectedCount(Year), sum(   {$<YearCalendario = {"=Year"}>}   OreDisp) ,0)

)))

It does not seem to work!

Thank you for any reply.

[#2]

Olá

Não sei se entendi bem o teu problema mas tenta assim (não testei!).

if( GetSelectedCount(Date(DataMovimento)) ,  sum( { <DayCalendario = {"Day(DataMovimento) "}>} OreDisp) ,

                if(GetSelectedCount(Settimana), sum(   {$<SettimanaCalend = {'Settimana'} >}   OreDisp) ,

                    if(GetSelectedCount(Month), sum(   {$<MonthCalendario = {"Month(DataMovimento)"}>}   OreDisp) ,

                         if(GetSelectedCount(Year), sum(   {$<YearCalendario = {"Year(DataMovimento)"}>}   OreDisp) ,0)

)))

Entretanto, se não funcionar mete um sample file

TMF