Hi,
I am facing issue with one of my report during the calculation like below. In variable selection, i'm entering US as a input so that, i will get US country License amount and Foreign amount with out US(Rest of Countries without variable entry country)
License Type
No of Licenses
US License Amt
Foreign License Amt
TYPE 1
10
5000
250000
TYPE 2
1
100
0 (No foreign Amount)
TYPE 3
15
12500
350000
TYPE 4
8
135000
12500
But In BEx getting below value for TYPE2 which is actually correct, Because restricting to not to display US country amount in foreign License amount, which will bring all the data except US/Entry.
In this case, I do not have any foreign amount for this TYPE2.
License Type
No of Licenses
US License Amt
Foreign License Amt
TYPE 1
10
5000
250000
TYPE 2
1
100
450000
TYPE 3
15
12500
350000
TYPE 4
8
135000
12500
However, my user want to see the Foreign amount based on the No of license with in that License Type and with Foreign country value.
Which means the calculation to get Foreign amount based on the No of Licenses.
No of licenses is based on the Entity number(Characteristic). Formula with Replacement variable.
License Type
No of Licenses
US License Amt
Foreign License Amt
TYPE 2
1
100
0 (No foreign Amount)
Kindly help me how to achieve this.
Thank you.