Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
I have an expression like below:
=sum( {< NEW_AGENT_NAME={'*'},NEW_ENTITY_CODE={'CPM078361*'},BILL_TYPE={'SELL'}>} sales)
I need to add a Day range to this in set analysis like from the 1st of a month to a particular date which is decided by value another column.
Example: Value in other column is 16 then it should show sales from 1st of the month to 16th. I have Day, DayMonth and Date field available as attached screenshot.
How can I use these fields in set analysis.
Regards
Chintan
=sum( {< Date = {">=$(=MonthStart(Max(Date)))<=$(=Max(Date))"}, NEW_AGENT_NAME={'*'},NEW_ENTITY_CODE={'CPM078361*'},BILL_TYPE={'SELL'}>} sales)