Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a scenario , where my i have to find the ddifference between the STATEMENT DATE , for NICK NAME and the condition is
Period Type = 'Year End'
Please find the attached excel of sample data
It will be as
if(Period Type = 'Year End',Interval(STATEMENT DATE-STATEMENT DATE2,'dd') as DifferenceTime
If are you going to showcase the data in table format?, then take a pivot table...
Dimension : Nick Name
Expression: Max({<Period Type ={'Year End'}>STMT_DT)-Min({<Period Type ={'Year End'}>STMT_DT)
Hi,
Try Interval() like this
=Interval(YearEnd([STATEMENT DATE]) - [STATEMENT DATE], 'DD') for getting the difference between the STATEMENT DATE AND Year end, if you want current year end then use below expression
=Interval(YearEnd(Today()) - [STATEMENT DATE], 'DD')
Regards,
Jagan.
which two date you want to make difference
if(Period Type = 'Year End',Interval(DATEfeidl1-Datefield2,'dd')