Could you please attach sample data as twbx and illustrate problem and expected result with using value example in that data.
Thanks for the quick response Shinichiro, i attached the twbx so you can see it.
What im expecting is:
- Inside the [Detail] calculated field im using a parameter to see SLA stages or SLA acum, in this case what is giving me troubles is SLA acum so focus on this one
- SLA_Acum uses the parameter SLA and the [I/O_ACUM] calculated field, please focus on this one, here i want to replace the number 103 that im using in every IF condition. Im wanna to put there the total of SLA that can i obtain from the secondary connection called "SLA" and using the column called SLA, the sum of all the rows in this column that gives me the total of 102 (Sheet 2)
You can create 2 calculated columns dummy in each of the sources and give it value 1 and make it dimension.
Now blend your 2 sources with dummy coumn and now you can use it further as you required.
Test (3).twbx 5.2 MB
Hi Ankit, thanks for the response, but this still doesn't help me.
I need to use that sum(SLA) from the second connection inside the calculated field I/O_ACUM from the main connection replacing each "103" value from that calculated field.