IF statement

[ajsjoshua]

Hi all,

I am facing problem with the If statement

suggest me some ideas

if(

     Max(Week_Up)<=8,

     Sum({< Year_UP ={$(=Max(Year_UP)-1)}, Week_UP = {"52 - (8 - Max(Week_Up)"} >}Orders),

     sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {"=$(=Max(Week_UP))"}>}Orders)

)

[PrashantSangle]

Hi,

can you tell your issue in details

in above expression you can try below

Week_UP = {"$(=52 - (8 - Max(Week_Up))"}

Regards

[ajsjoshua]

Hi dreamer4

Whenever Max(Week_Up) will be less than 8 it become -ve.

[susovan]

Hi joshua,

Try this expression,

if(

     Max(Week_Up)<=8,

     Sum({< Year_UP ={"$(=Max(Year_UP)-1)"}, Week_UP = {"52 - (8 - Max(Week_Up)"} >}Orders),

     sum({<Year_UP = {"$(=Max(Year_UP))"},Week_UP = { "$(=Max(Week_UP)-8)"},Week = {"=$(=Max(Week_UP))"}>}Orders)

)

[ajsjoshua]

Hi Susovan Ghosh,

Its not working.

[PrashantSangle]

Hi,

In your set analysis expression

52 - (8 - Max(Week_Up) this will treat as string , It will not return any value.

For that you have to modify it like

{"$(=52 - (8 - Max(Week_Up)))"}

Note : You have also missing ) bracket.

Regards

[susovan]

Try this,

if(

    Max(Week_Up)<=8,

    Sum({< Year_UP ={">=$(=Max(Year_UP)-1)"}, Week_UP = {">=$(vWeek)"} >}Orders),

    sum({<Year_UP = {">=$(=Max(Year_UP))"},Week_UP = { ">=$(=Max(Week_UP)-8)"},Week = {">=$(=Max(Week_UP))"}>}Orders)

)

Here vWeek="=52 - (8 - Max(Week_Up))"

[ajsjoshua]

Hi Susovan Ghosh

Its taking entire week_Up bro,

[susovan]

Can you tell me what is the actual output?