Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%')
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%
It seems to be a MTD (Month to Date) calculation of P_AND_L divided by OPENING_CAPITAL
HI Vignesh,
Calculating % of P_AND_L & OPENING_CAPITAL for MTD (Month to Date)
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
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%
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.