Determine if there is data in past 24 months of Actuals

2 weeks ago 7

Hi @raf_lim 

we had a akin petition from business. Our attack to lick it was to first, marque a caller cardinal figure. Within this cardinal fig we manipulated the actuals, to either usage the corresponding actuals successful the past. If determination were nary actuals (isnull), we alternatively filled the cardinal fig with a 0.

Next, we utilized an XYZ-segmentation. In the segmentation we utilized the manipulated actuals qty cardinal fig mentioned above, added the requested skyline (in your lawsuit 24 months) with a calculation strategy "aggregate of periods", aggregation method "sum" and segmentation method "(1) by Threshold". By doing so, you tin make a threshold successful "smaller than oregon adjacent to" 0 which gives you a conception with nary actuals, portion evereything bigger than 0 has actuals.

Using a segmetation allows you to easy capable an attribute, that the extremity idiosyncratic tin use to filter successful the excel adhd successful oregon planner workspace.

If you person further questions (e.g. implementation screenshots), conscionable scope retired to me. I'm blessed to help.

Best regards,
Matthias

Read Entire Article