Hi All,
I have to display my report like below. in Variable screen will enter US as a country, so that State License Value shows value for US and License value foreign shows the value except US.
Type 2 License is having only 1 license and state license value is 2500. and in this example i do not value for foreign License value.
Licence Type No of Licenses State License Value (US) License Value(Foreign) Type 1 30 15000 350000 Type 2 1 2500 0 Type 3 10 1250 45000But in the output of the report it showing like below. which is actually correct. because i have data for type2 with License Value Foreign, But as per my user he want to see the License value for Foreign is "0" for type 2.
Licence Type No of Licenses State License Value (US) License Value(Foreign) Type 1 30 15000 350000 Type 2 1 2500 125000 Type 3 10 1250 45000The calculation for the State & Foreign license value should be based on the No of licenses and license value for the each state is not a standard value. its based on the shareholder %.
No.of License is calculated based on Number of License(characteristic) with formula variable.
Kindly help me out how to get this output.
Thank you.