2 Replies Latest reply: Mar 23, 2018 10:53 AM by Dan Green RSS

    Set Analysis to show range of dates until others are selected

    Dan Green

      Hi,

       

      I created a flag field to indicate which rows are for the last 5 days of data (CEDateFlag = {1}). Is there a way to have this or something similar UNTIL other dates are selected from a list? At that point I would like it to show the selected dates until the selections are cleared.

       

      IF([Amount/Count] = 'Count', Num(Sum($(vCollEff)CE0_30Cnt)/1000,'###K;(###K)'), Num(Sum($(vCollEff)CE0_30Amt)/1000000, '$###M;($###M)'))

       

      Where $(vCollEff) = {$<CEDateFlag = {1},ReceiptType=,ReceiptStatus>}