Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
this works:
=count ( {$<AnalysisDate={">=8/9/17"}>} Rate)
this doesn't work:
=count ( {$<AnalysisDate={"=8/9/17"}>} Rate)
this doesn't work:
=count ( {$<AnalysisDate={">=$(max(DateTo))"}>} Rate)
*DateTo is a Field, max(DateTo) should give 8/9/17
suggestions?
thanks!
Luigi
Hi Luigi,
=count ( {$<AnalysisDate={'8/9/17'}>} Rate) // = sign removed
=count ( {$<AnalysisDate={'>=$(=max(DateTo))'}>} Rate)
Regards,
Antonio
Hi Luigi,
=count ( {$<AnalysisDate={'8/9/17'}>} Rate) // = sign removed
=count ( {$<AnalysisDate={'>=$(=max(DateTo))'}>} Rate)
Regards,
Antonio
this doesn't work:
=count ( {$<AnalysisDate={"=8/9/17"}>} Rate)
this will work
=count ( {$<AnalysisDate={"8/9/17"}>} Rate)
this doesn't work:
=count ( {$<AnalysisDate={">=$(max(DateTo))"}>} Rate)
this will work
=count ( {$<AnalysisDate={">=$(=max(DateTo))"}>} Rate)
it works, thank you!
now I have a new problem, if I create the variable
set vRate=count ( {$<AnalysisDate={">=$(=max(DateTo))"}>} Rate);
and I try to solve the variable in the expression
=$(vRate)
I don't get the value
Try like
= $(=vRate)
thanks!