Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me to understand the next expression?
sum({$<
METRIC_TYPE={'TtO' }
, CREATIONTIME={">= $(= vFromDate ) < $(= vToDate +1)"}
>} $(TIME_FACTOR) )
Thanks,
Boris
no , not sum for all value,but for those value, who fall in the below criteria,
Where Metric_Type = "Tto" and Creation_Time is Greater Than or equal to vFromDate and
Creation_Time Less Than vToDate plus one day.
Hi,
vFromDate = taking input from user are have assigned a default value
vToDate, same like above, but adding +1 day
This Expression is doing Sum of Time_Factor, that is a field in Data Source.
But Only those Time Factor, Where Metric_Type = "Tto" and Creation_Time is Greater Than or equal to vFromDate and
Creation_Time Less Than vToDate plus one day,
for example vToDate contain a date like 20/11/2013, then vToDate + 1 will be 21/11/2013.
Hope will help,
sorry if i could not explain well
Looks correct except of the $(TIME_FACTOR). From the expression syntax it is rather a variable than a field. That is, the expression returns sum of the field specified in this variable, with the conditions as you've described.
Regards,
Michael
Hi Michael,
OOOPS , did not realized that its a variable.
Thanks for corrections.
It is indeed a field that is assigned into this variable.
does it mean that the sum is for all the values in this field even if it is assigned to a variable?
Thanks,
I think yes
no , not sum for all value,but for those value, who fall in the below criteria,
Where Metric_Type = "Tto" and Creation_Time is Greater Than or equal to vFromDate and
Creation_Time Less Than vToDate plus one day.