find the sum value of last day in month

[#1]

Hello,

I want to figure out the total amount of the last day in each month, the last day is last business day, for example 26 Apri instead of 30 April, how to draft expression then ?

Attached pls find raw data for tesing.

Thanks.

[sunny_talwar]

What is your expected output for the data you have shared?

[sunny_talwar]

This?

Script:

Table:

LOAD Company_Name,

    Date,

    Day(Date) as Day,

    MonthName(Date) as MonthYear,

    Stock

FROM

Community_174109.xlsx

(ooxml, embedded labels, table is Sheet1);

Dimension:

Company_Name

Date

Expression:

=If(Aggr(NODISTINCT Max(Day), MonthYear, Company_Name) = Day(Date), Sum(Stock))

[Kushal_Chawda]

Please see the attached

[#5]

Hi,

That's working, thanks.

Rgs,

Jessica