Explanation

[vignesh_s]

hi all,Can any one expalin ths expression

=num(Sum({<DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} P_AND_L)/

        Sum({< DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} OPENING_CAPITAL),'0.00%')

[sunny_talwar]

It seems to be a MTD (Month to Date) calculation of P_AND_L divided by OPENING_CAPITAL

[sasikanth]

HI Vignesh,

Calculating  % of P_AND_L & OPENING_CAPITAL  for MTD  (Month to Date)

[stabben23]

Looks lika a MTD KPI in %, probably in a textobject.

so if you have max Datenum today it will calculate from 1/1/2108-23/1/2018

[shiveshsingh · Accepted solution]

Meaning of  --- Sum({<DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} P_AND_L)

Sum of P_AND_L where datenum is greater than or equal to month start of Max(Datenum) and less than or equal to Max(Datenum)

Meaning of ---- Sum({< DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} OPENING_CAPITAL

Sum of OPENING_CAPITAL where datenum is greater than or equal to month start of Max(Datenum) and less than or equal to Max(Datenum)

Post this, they have done formating by usning '0.00%

[surendraj]

A KPI that shows MTD Caliculation By dividing P_AND_L with OPENING_CAPITAL and finally formated(0.00% ) by make use of num function.