Need Help??

[paulwalker]

Hi Community,

I am using this expression comparing with Date and Today().

LOAD *, IF(NETWORKDAYS([Date],TODAY())-1=0,'Day 0',

                   IF(NETWORKDAYS([Date],TODAY())-1=1,'Day 1',

                          IF(NETWORKDAYS([Date],TODAY())-1=2,'Day 2',

                                  IF(NETWORKDAYS([Date],TODAY())-1=3,'Day 3',

                                        IF(NETWORKDAYS([Date],TODAY())-1=4,'Day 4',

                                              IF(NETWORKDAYS([Date],TODAY())-1=5,'Day 5','Days >5'))))))  as Aging

Here i am comparing with Today() date, but i want change based on date selection..

Earlier i have proper data up to Today's date... but present i don't have 2015 data..(Direct it goes to else part)

How to write Expression???

[senpradip007]

Could you upload sample qvw?

[its_anandrjs]

Hi,

Try with this expression

LOAD *, IF(NETWORKDAYS([Date],Max([Date]) )-1=0,'Day 0',

                   IF(NETWORKDAYS([Date],Max([Date]))-1=1,'Day 1',

                          IF(NETWORKDAYS([Date],Max([Date]))-1=2,'Day 2',

                                  IF(NETWORKDAYS([Date],Max([Date]))-1=3,'Day 3',

                                        IF(NETWORKDAYS([Date],Max([Date]))-1=4,'Day 4',

                                              IF(NETWORKDAYS([Date],Max([Date]))-1=5,'Day 5','Days >5'))))))  as Aging

Regards,

Anand