Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to make a syntax as shown below. I am trying to sum the ours that are planned in the future. So all the ours after today.
if(MAXIMALPRODUCTIONFINISHDATE > Today(), Sum([B_TOTAL_TIME_H:MM:SS]))
but it is not giving a value, any tips or tricks?
#KPI Chart
I missed the () at end of Today.
try below
Sum(if(floor(MAXIMALPRODUCTIONFINISHDATE )>Floor(Today()),B_TOTAL_TIME_H:MM:SS))
Regards
Prashant Sangle
Hello
try
Sum(if(floor(MAXIMALPRODUCTIONFINISHDATE )>Floor(Today),B_TOTAL_TIME_H:MM:SS))
Regards,
Prashant Sangle
hi Prashant,
thx for your answer but it is giving me a wrong expression...
am i doing something wrong
I missed the () at end of Today.
try below
Sum(if(floor(MAXIMALPRODUCTIONFINISHDATE )>Floor(Today()),B_TOTAL_TIME_H:MM:SS))
Regards
Prashant Sangle
thx a lot!! that worked for me!