Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, hope you can help me, I created a field in my script QuarterName(UNIT.SOLD_DATE) as UNIT.SOLD_QTR,
so that I can use it in my set analysis, sum({<UNIT.SOLD_QTR = {$(=QuarterName(today()))}>} UNIT.TOTALSOLD)
but I think I'm getting the syntax wrong, can anyone help me please, Thx Simon
Would be easier if you attach your qvw, but try this first
sum({<UNIT.SOLD_QTR = {"$(=QuarterName(today()))"}>}UNIT.TOTALSOLD
Would be easier if you attach your qvw, but try this first
sum({<UNIT.SOLD_QTR = {"$(=QuarterName(today()))"}>}UNIT.TOTALSOLD
Perfect, thank you