Skip to main content

Hi All,

 

I have the monthly data for a year, i want to show last day of the month sales as entire sales for month, and if the last day of the month has no sales or NULL then it should show previous day sales.

 

For example:

for 2019, Jan 31st i dont have any data, then it should show previous day sales.

7 réponses
  1. 11 mars 2020, 11:10

    Hi, Krishna

     

    change your last day sales calculation as below to get the latest no null value for each month

    Hi, Krishna change your last day sales calculation as below to get the latest no null value for each month Workbook attached for your reference.

     

    Workbook attached for your reference.

     

    Hope this helps

     

    ZZ

0/9000