tampara.dora
Occasional Contributor

Last day of month for line item

Hi,

How do I get the last day of the month for a given line item when the module is dimensioned by Time? Please help.

我需要t的最后一天he month for the line item in the screen shot.

1 ACCEPTED SOLUTION

Accepted Solutions
ManjunathKN
Valued Contributor

Hi

if you have specific line item to be compared.
please check below formula.

ManjunathKN123_0-1642541016529.pngManjunathKN123_1-1642541045449.png


Thanks
Manjunath

View solution in original post

3 REPLIES3
ManjunathKN
Valued Contributor

Hi

Please use END() formula with Date formatted Line item.

Thanks.

ManjunathKN
Valued Contributor

Hi

if you have specific line item to be compared.
please check below formula.

ManjunathKN123_0-1642541016529.pngManjunathKN123_1-1642541045449.png


Thanks
Manjunath

tampara.dora
Occasional Contributor

Thank you, that helps!!