Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lessassy
Creator
Creator

Mathematical division in link table doesn't show result

Hello everyone,

 

I have two field in my scripts that are on differents table.

TAB_1:

Load *

Measure_1 from xyz;

 

TAB_2:

Loa *

Measure_2 from abc;

I have a Fact table which has all my main field:

FACT_TABLE

Load *

SUM(Measure_1)/Sum(Measure_2) as KPI

 

The thing is when i make this calculation in a set analysis i get data but here i get zero values... or no values at all.

Could anyone help me on that matter ?

thank you

 

 

 

Labels (1)
0 Replies