EazyBI - calculating problems or import from database

[Rafał Kiersztejn]

Hi, guys
I've got two tables from two reports for the sake of simplicity, let's take the numbers 501 and 305.

Report 501 is about scope of test and got column:
Zawansowanie kroków = Advancement of the test step,
which contains measure: 

CASE 
WHEN CurrentTuple(VisibleRowsSet()).Item(0).Name = '$total_aggregate'
THEN
Avg(VisibleRowsSet(),
([Measures].[Count of test step succes] + [Measures].[Count of test step cancel]) / ([Measures].[Count of test step])
)
ELSE 
([Measures].[Count of test step succes] + [Measures].[Count of test step cancel]) / ([Measures].[Count of test step])
END

 

Report 305 is about daily progress and got column:
Zaawanoswanie testów = Advancement of the tests,
which contains measure:

IIf(
DateDiffDays(
DateWithoutTime([Time].CurrentHierarchyMember.StartDate),
DateWithoutTime(Now())
) >= 0, 
[Measures].[Advancement of the tests (all)], NULL)

I expected the result of calculation will be the same figure. So the total of the column form report 501 will be the same as the row from current day from report 305, but it isn't.
Is this problem with calculation in measures or with import from database? 

If you have question about any details feel free to ask.

[Janis Plume _eazyBI_]

Hi, @Rafał Kiersztejn 

Please, contact eazyBI support with more details.

We need to see the report definitions containing the full details of the report design, so we can check if it is expected that the results in those two reports should match.

Kindly.

Janis, eazyBI support