Skip to Content
0
Former Member
Aug 02, 2016 at 06:26 AM

Calculation based on the variable

28 Views

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.