Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey I would like to something like, sum TransactionAmount thats between start and end dates, ( i would like to get the sum of transactions in a selected month )
if anyone could please point me in the right direction.
SUM( {< Year=, PeriodName=, postingDate={"<=$(vEndDate)" AND ">=$(vStartDate)"} >} TransactionAmount)
thanks.
Bon.
try:
SUM( {< ... postingDate = {"<=$(vEndDate)" } * {">=$(vStartDate)"} >} ...
Hi,
Try like this
SUM( {< Year=, PeriodName=, postingDate={">=$(vStartDate)<=$(vEndDate)" } >} TransactionAmount)
Note : postingDate, vStartDate and vEndDate should be in the same date format.
Regards,
Jagan.
Try this way also
SUM( {< Year=, PeriodName=, postingDate={' >=$(vStartDate) <=$(vEndDate) ' } >} TransactionAmount )
Or
SUM( {< Year=, PeriodName=, postingDate={" >=$(vStartDate)<=$(vEndDate) " } >} TransactionAmount )
Regards
Anand
Hi,
Here no need to menstion AND
you can try this one
SUM( {< Year=, PeriodName=, postingDate={"<=$(vEndDate) >=$(vStartDate)"} >} TransactionAmount)
Hey
Thanks for all your help, some worked some didn't, still it hasn't given me the results I was after,
maybe its something wrong with my codes. will go through everything again.
thanks.
Bon.
Hi, check the field format postingDate and variable return in same format.
SUM( {$<Year=, PeriodName=, postingDate={">=$(vStartDate)<=$(vEndDate) " }>} TransactionAmount )
Best Regards.
Tonial.
Issue might be due to date format. If you can not figure out, can you post sample qvw
Hi,
May be This works:
SUM( {< Year=, PeriodName=, postingDate = {" >=$(=vStartDate) <=$(=vEndDate) "}>} TransactionAmount )
Best,
Robert
Hi,
Try like this
SUM( {< Year=, PeriodName=, postingDate={">=$(vStartDate)<=$(vEndDate)" } >} TransactionAmount)
Note : postingDate, vStartDate and vEndDate should be in the same date format.
Check date format of postingDate in list box and variables in vStartDate and vEndDate in text objects all should be in the same date format.
Hope this helps you.
Regards,
Jagan.