TY Vs LY Sales comparison status

[nareshthavidishetty]

Hi ,

We are comparing current year vs last year sales.

Here we need like if today(9/21/2017) sales is 100 and last year(9/21/2016) sales is 0 (or) today's sales is 0 and last year sales is 100 then we need to put the status as In-Active.

Please find the attached Sample requirement design.

Is it is possible by using if Condition.

Thanks...

[sunny_talwar]

In the script? Yes, may be like this

If([2017 Sales] = 0 or [2016 Sales] = 0, 'In-Active', 'Active') as Status

[nareshthavidishetty]

Hi,

[2017 sales] is an sample column name and we need to derive sales dynamically based on year.

Thanks..

[nareshthavidishetty]

Hi,

Any clue..

Thanks..