Sum If date condition

[davyqliks]

Hi,

I need to only show the last order date if greater than 90 days old.

I have used the condition in the colour function to highlight red and it worked like this:

if(Today()-90>= Only( [Last Order Date UK]),
rgb(255,26,26),)

But i now need to only show the line and date if this condition is met:

I use the below which in my mind looks right with no syntax issue but the date returns 0

if(Today()-90>=,Only({$<Location = {'UKInv'},[Retailer Name] = {'ASOS'}, [Item Default Production Method] = {'In-House(Stock)','Outsource(Stock)'}>}[Last Order Date]))

Can someone inform how i can display the date when only older than 90days with this set analysis.

Thank you

[Brett_Bleess]

@davyqliks  It would likely be most helpful at this point if you attach a sample QVW file with the issue, so folks can dig into things a bit more deeply, believe that is the best avenue forward on this one to ensure you get a good solution.

Regards,
Brett

[davyqliks]

Hi All,

To update i ended up using an if flag True false in the load and using this in set analysis.

Thanks  for your help.

Load

if( (Today()-[Last Order Date])>=90,True(),False() )as [RO>90FLAG],

expression in chart

Sum({< [RO>90FLAG] = {'-1'} >}[Stock Estimated Balance RO] * ([RO Invoice Item Unit Price] * 0.9021000 ))

I hope this may help somebody going forward.

Daniel