Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can you post a sample data?
try this
SUM(if(timestamp#([incident date])>=Timestamp#([Start Date]) and timestamp#([incident date])<=TimeStamp#([End Date])
and [Authorized Amount] > 0, Authorized Amount] ,
if(timestamp#([incident date])>=Timestamp#([Start Date]) and timestamp#([incident date])<=TimeStamp#([End Date])
and [Authorized Amount] =0,[Claimed Amount])))
This is what i get, what am i doing wrong?