What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
Can anyone tell me what these functions are for?
I have read Anapedia but still having a hard time understanding what they do.
In the sample below, I guess that "each weekly sales" are compared to "average weekly sales."
And it turns out to be "True" if a weekly sales is greater than average, but I don't understand why MONTHVALUE has to be used, instead of WEEKVALUE.
In this example, a Product Sales module has line items on rows and Time on columns. The Net Profit line item has a numeric data type, and the Week above average for month line item has a Boolean data type.
In Blueprint, in the Summary column for Net Profit, Time Summary is set to Average. The formula returns a TRUE result for values that are above average for each week in the month.
|Week 1 FY21||Week 2 FY21||Week 3 FY21||Week 4 FY21||Jan 21|
Week above average for month
Net Profit > MONTHVALUE(Net Profit)