Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I have data like below and Its linked with Sales table with the key combination of 3 Fields i.e. Customer Cat1, Item#, and Year(Year derived from FromDate field)
I need to calculate Markdown value on Sales Qty which is in between FromDate and Todate.
Example: Customer Cat1(370665) and Item#(38725-143)
For the above example we have FromDate(01-02-2020(MM-DD-YYYY)) and Todate(31-07-2020(MM-DD-YYYY)) and the Amount should calculate from the Amount filed, i.e. 9.00
Example: Need to calculate the Markdown Rs. 9.00 is on Sales Qty which is in between FromDate(01-02-2020(MM-DD-YYYY)) and Todate(31-07-2020(MM-DD-YYYY))
I have used the below Expression, however its not working.
Sum({< YearPeriod = {$(=Max(RequestYearPeriod)-1)}, InvoiceDate={" >= (FromDate) <= (ToDate) "} >} Qty) * Amount
Can any one help me on this with high priority.
Regards and Thanks,
Raghu
The expression editor should display what it will evaluate to at the bottom of the screen. Not sure if you need $(FromDate) perhaps or '$(FromDate)' to ensure the dates have single quotes around them. The Expression editor syntax at the bottom of the screen will display what is wrong and that usually helps especially since you already understand Set Analysis.
Hello @Dalton_Ruer
I have tried this, however its not working
Can any one help me on this ASAP
regards,
Raghu