Hi all,
I need help on the below logic. My requirement is as below:
I have two filters :
1. Sales Over Amount
2. Sales Under Amount
I have a table with as below:
| Vehicle No |
Amount ($) |
| ABCD12 |
15 |
| DEFG13 |
16 |
| GHTY56 |
18 |
| HJKU76 |
19 |
So i created varaibles as below:
vSalesUnderAmount
Only({<[Transaction Date]={">=$(=$(vDateFrom)) <=$(=$(vDateTo))"},
[Transaction Month]=,[Transaction Week]=,BillingMonthNameAbbr=>}
if(GetSelectedCount([Sales Under Amount]) > 0,GetFieldSelections([Sales Under Amount]),'1000000000'))
vSalesOverAmount
Only({<[Transaction Date]={">=$(=$(vDateFrom)) <=$(=$(vDateTo))"},
[Transaction Month]=,[Transaction Week]=,BillingMonthNameAbbr=>}
if(GetSelectedCount([Sales Over Amount]) > 0,GetFieldSelections([Sales Over Amount]),'1000000000'))
The above two variables i have included in the below varaible:
vSales
Sum(
{<[Transaction Date]={">=$(=$(vDateFrom)) <=$(=$(vDateTo))"},TranDateTime={"=sum(Sales)<=$(=num($(vSalesUnderAmount)))"}>*
<[Transaction Date]={">=$(=$(vDateFrom)) <=$(=$(vDateTo))"},TranDateTime={"=sum(Sales)>=$(=num($(vSalesOverAmount)))"}>}
Sales)
My requirement is
So when i select Sales Over Amount 15, my table should only reflect only the amount Over 15.
when i select Sales Under Amount 15, my table should reflect only 14 amount in the table.
if i select Sales Over Amount 15 and Sales Under Amount 18, it should reflect only 16 in the table.
Please help.
