topic Re: IF Statement - Date in App Development

IF Statement - Date

jerryr125 — Fri, 25 Jun 2021 17:32:38 GMT

Hi - I am creating a column a pivot table visualization for a dimension.

I am using the following expression and the IF statement is not working (always going to FALSE).

=IF([skdate.autoCalendar.Year]=2021,skid,null())

Any thoughts ? Jerry

Re: IF Statement - Date

edwin — Fri, 25 Jun 2021 18:39:38 GMT

you may need to supply sample data.

however, if what you want is evaluate your table only for year=2021, maybe the condition should be in your expression as set analysis instead of dimension. and it will be faster