Are these values original fields or calculated fields?
If calculated fields, does it contain today function?
If original fields and the data source is Excel, does the field in Excel contains random function?
Better attach a sample workbook for further investigation.
Hello Lei ,
Values are calculated field and not using Random or today function . Its is simple Average calculation by picking 3 month value based on condition .
mausami sharma wrote:
Its is simple Average calculation by picking 3 month value based on condition .
Does the condition contain something like relative date? For example, last 3 months?
This issue got fixed by system formatting.