topic Re: Convert if statement to pick - match function in App Development

Convert if statement to pick - match function

madnanansari — Mon, 09 Oct 2017 12:41:44 GMT

How to convert the below if statement to pick - match combination:

If(getselectedcount([Year])<1 and getselectedcount([Month Year])<1

Sum({$<[Month Year]=,[Year]=,[MonthID]= {"$(=((Year(Today()) -1)*12) + Num(Month(Today())))"}>} [Target])

Sum([Target])

)

Re: Convert if statement to pick - match function

sunny_talwar — Mon, 09 Oct 2017 13:01:40 GMT

I don't think this can be converted to a pick match statement....

Re: Convert if statement to pick - match function

swuehl — Mon, 09 Oct 2017 13:12:47 GMT

Maybe you can use a pick/ match combination here, but I believe without any benefit.

Pick( Match( getselectedcount([Year]) &'-'& getselectedcount([Month Year]), '0-0'),

...

Re: Convert if statement to pick - match function

pradosh_thakur — Mon, 09 Oct 2017 13:22:06 GMT

Try this

pick(match(getselectedcount([Year])&getselectedcount([Month Year]) ,'00')+1, Sum([Target]),Sum({$<[Month Year]=,[Year]=,[MonthID]= {"$(=((Year(Today()) -1)*12) + Num(Month(Today())))"}>} [Target])

regards

Pradosh

Re: Convert if statement to pick - match function

swuehl — Mon, 09 Oct 2017 13:31:05 GMT

Yes, like pradosh suggested, you should use a +1 to account for a default value and change the order of expressions accordingly.

But still, I believe this won't perform better nor be better maintainable than the original If().