Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to convert the below expression to MTD
Count(if(not IsNull(ONBL) and Len(Trim(OFBL)) <=0 ,FLNO))
Please elaborate more
Or you can use a expression like
Count( {<Datefield = {'>= $( =Monthstart(Datefield) ) <= $( =Today(DateField) ) '}>} FLNO)
What is the use of not IsNull(ONBL) and Len(Trim(OFBL)) fields
this is the calculation condition for counting the Flight no.,now the user want to see this value on month on month basis