Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following scenario. I have 3 Fields. Type, Month_Numeric, Score.
Type is made of Assessments and Closures.
A selection will be made for a particular month say Jan 2019. I need to sum the scores for the closures for that date selection (Sum Score for Closures in January) but also include All Assessments from the beginning of time in the Sum. Date doesn't matter for Assessments.
So Sum will be Type='Closures ' AND Month_Numeric=GetCurrentSelection(MonthNumeric) + Sum of All Type='Assessment' For All Months from history.
Whats the best way to go about this?