Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hiii community
i am having a problem
i am having a table in that there are two coulm clm_intimation_date and clm_xgen_num .
i am having data from >=01-Jan-2015 <=31-Jul-2016 and clm_xgen_num of this period ie 1 year
now what i want is that i want latest month ie july all the clm_xgen_num
how can i get it
can u help me in this
in advance thank you
Why not this,
Sum({<month = {'july'}>} clm_xgen_num)
OR
If you want to show year 2016
Sum({<month = {'july'}, year = 2016>} clm_xgen_num)
Here month is
Month(datefield) as month
Hi Sagar,
Check this,It will returns the latest month in the data feild as month(datefeild) as month.
Sum({$<Month={$(=Max(Month))}>}[Sales]).
Thanks
Kumar KVP
if i want latest claim of 20 days then