How to write expression on sum of capital ( Eg: sum of 2016 Nov to 2018 April)

[#1]

I have data from Nov 2016 to April 2018. can any one share how to write expression for sum.

[Frank_Hartmann]

try like that:

Sum({<Date={'>=$(=MonthStart(makedate(2016,11))) <=$(=MonthStart(makedate(2018,4)))'}>} Sales)

hope that helps

[sunny_talwar]

Not sure I understand, do you want this? Sum(Capital)?? If this is not what you want, would you be able to expand on your requirements

[MK_QSL]

=SUM(Sales)

or

SUM(Value)

[#5]

Its working but team says its hard code

[#6]

want to sum the Finance Amount for the period of Nov 2016 to April 2018

[sunny_talwar]

What is the reason for picking this date range?

[#8]

need to show the sum of Finance Amount in KPI