Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
Could you upload sample qvw?
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