current day logic

[soniasweety]

Hi all,

Antonio Mancini

I have a scenario like below  attached with sample data and with example.

and how can set the day of the week  ?  how to this in scripting?  and in  front end how to approach?

Thanks

Sonica

[soniasweety]

and the expression if write like below its working but if I write total condition its not working'

count({<Task_DurationDays={'<=15'}>}number)

it is showing lesthan 15days numbers but full expression if I use nothing is displaying

[soniasweety]

your expression is working but it is showing all more than 3days even though there is less than 3days duration values also.

[antoniotiman]

See Attachment

[antoniotiman]

New Attachment

[soniasweety]

Hi,

LET vDay = Num(WeekDay(Today()))+1;

this variable displys today+1  y this?  why cant we use only today? any specific reason?

[antoniotiman]

Because QV Logic is Mon -> 0 and Your Logic is Mon -> 1

[soniasweety]

thanks  for clarification. how can I include this in below expression

Antonio Mancini                   

aggr(If(Match(vDay,1,2,3,7),Only({<Task_DurationDays={'>5'}>} Task_DurationDays
),
If(Match(vDay,4,5),Only({<Task_DurationDays={4,5}>} Task_DurationDays),
if(match(vDay,6),Only({<Task_DurationDays={'>=4'}>} Task_DurationDays)))),TaskName)

"  only(if(isnull(Assignedto), Number))"    this also part the of expression. 

I want the above criteria along with the field assignedto value is null.

[antoniotiman]

I'm sorry, I don't understand. What is Your new logic ?

[soniasweety]

the logic is the report is like to display the numbers where the filed assignedto is null along with the  day logic criteria

[d_prashanthredd]

You mean, that expression/calculation should execute if the assignedto value is null??