Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've written an expression to calculate revenue invoiced today using a variable but I can't seem to get the syntax correct. I keep getting error in set modifier ad hoc element list: ',' or ')' expected.
Here is my expression:
=Money(sum({<TRANDATE={$=vToday},TRANSACTION_ORDER={'0'}>}AMOUNT))
I figured out the issue. My TRANDATE field did not have the same date format as my vToday variable, so I just created a new TransDate field that has the same format. Now when I plug that field into the expression you gave me it is returning a value. Thank you for your help with the expression.
Try this:
=Money(sum({<TRANDATE={'$(vToday)'},TRANSACTION_ORDER={'0'}>}AMOUNT))
Hi,
have you tried
=Money(sum({<TRANDATE={$(=vToday)},TRANSACTION_ORDER={'0'}>}AMOUNT))
=sum {$ <TRANDATE={$(vToday)},TRANSACTION_ORDER={0}>}AMOUNT)
This expression is at least not returning an error, but the amount I am getting is 0. It should be around 100K, so I need to figure out what I am still doing wrong.
Can you post a sample?
I figured out the issue. My TRANDATE field did not have the same date format as my vToday variable, so I just created a new TransDate field that has the same format. Now when I plug that field into the expression you gave me it is returning a value. Thank you for your help with the expression.