Hello,
We have this aggregated table:
AggreageatedTableA
PrimaryKey Amnt
------------------------
111 950
666 500
777 1000
DetailedTableB
column1PrimaryKey ForeignKey %
---------------------------------------------
100 666 0.25
101 666 0.50
102 666 0.25
103 777 0.10
104 777 0.50
etc...
Question:
will we be aloud to perform from Report Studio AND Query Studio calculations by using the [Amnt]
column from the "AggreageatedTableA" and the [%]
column from "DetailedTableB" to create a new Data Item with the following calculation:
[Amount] * [%]
Ex:
If we take the PrimaryKey = 666 from AggreageatedTableA
We expect to have the following detailed results in a simple list report using columns from both tables
(the aggregated one and the detailed one):
PrimaryKey ForeignKey % Amount
666 666 0.25 125
666 666 0.50 250
666 666 0.25 125
Quote from: sanchoniathon on 05 May 2016 02:56:01 PM
Hello,
We have this aggregated table:
AggreageatedTableA
PrimaryKey Amnt
------------------------
111 950
666 500
777 1000
DetailedTableB
column1PrimaryKey ForeignKey %
---------------------------------------------
100 666 0.25
101 666 0.50
102 666 0.25
103 777 0.10
104 777 0.50
etc...
Question:
will we be aloud to perform from Report Studio AND Query Studio calculations by using the [Amnt]
column from the "AggreageatedTableA" and the [%]
column from "DetailedTableB" to create a new Data Item with the following calculation:
[Amount] * [%]
Ex:
If we take the PrimaryKey = 666 from AggreageatedTableA
We expect to have the following detailed results in a simple list report using columns from both tables
(the aggregated one and the detailed one):
PrimaryKey ForeignKey % Amount
666 666 0.25 125
666 666 0.50 250
666 666 0.25 125
Hi,
You'd need to have a relationship linking these two query subjects in your FM model. You also need to think carefully about what you include in the report - if you don't bring in the PrimaryKey from the detailed table, your list would display a single aggregated row for ForeignKey 666, and it doesn't look like this is your requirement?
MF.
Thank you MF,
I will take into consideration to include the detailed table PrimaryKey because I need to see the detailed rows not only 1 grouped row (not for this need).