Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Wanted to know if this is the proper way to calculate data on selection of filter YTD,QTD,MTD. Or is there any other way how i can do it?Thanks for your suggestions.
if(Filter='YTD' or GetSelectedCount(Filter)=0,
only({<POSITION_DATE= {">=$(=vytdstart)<=$(=vytdend)"}>} maturity)
,
if(
Filter='MTD',
only({<POSITION_DATE= {">=$(=vmtdstart)<=$(=vmtdend)"}>} maturity),
IF(Filter='QTD',
only({<POSITION_DATE= {">=$(=vqtdstart)<=$(=vqtdend)"}>} maturity)
)
)
)
Thanks,
Shreya
Use Sum instead of ONLY, Your expression logic is correct:
if(Filter='YTD' or GetSelectedCount(Filter)=0,
Sum({<POSITION_DATE= {">=$(=vytdstart)<=$(=vytdend)"}>} maturity)
,
if(
Filter='MTD',
Sum({<POSITION_DATE= {">=$(=vmtdstart)<=$(=vmtdend)"}>} maturity),
IF(Filter='QTD',
Sum({<POSITION_DATE= {">=$(=vqtdstart)<=$(=vqtdend)"}>} maturity)
)
)
)
Hi arjun,
the maturity field has dates so we want to use only of the maturity/segment.
Also i am facing out of memory issue.Is there any other way to handle it.Thanks
That date field convert into num
eg: num(POSITION_DATE)
then you apply
That date field convert into num
eg: num(POSITION_DATE)
then you apply
Try to share an app with sample data replicating your ask. That way, we would be able to help you better and faster.
It is much to share the sample data to provide exact solution.shreya.nadkarni