Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Equation giving value for january and feb 2022 so whats i am doing wrong here also want to use vstartdate as variable for 06/01/2022.
=SUM({<PayPeriod.ServiceDT= { ">=$('6/01/2022')"},PayPeriod.ServiceDT= {'<=$(VEndDate)'} >} PayPeriod.APCWeight)
If you are having trouble with this, check what the result is using the Expression editor and look at the bottom to see if there is any errors.
The rules in the set expression is to search for a range of values needs " " quotes.
Another thing that can sometimes happen is date formatting issue.
Assuming you have a variable containing '06/01/2022'
=SUM({<PayPeriod.ServiceDT= { ">=$(vstartdate)<=$(VEndDate)"} >} PayPeriod.APCWeight
If you are having trouble with this, check what the result is using the Expression editor and look at the bottom to see if there is any errors.
The rules in the set expression is to search for a range of values needs " " quotes.
Another thing that can sometimes happen is date formatting issue.
Assuming you have a variable containing '06/01/2022'
=SUM({<PayPeriod.ServiceDT= { ">=$(vstartdate)<=$(VEndDate)"} >} PayPeriod.APCWeight
Thank you Lisa.