I have a table in the 'Filter_Option' attachment that is filtered based on a client and it shows different values with relation to no.of cases and amounts based on different periods in days.
I have a further drilldown option when you click the orange button which directs you to the `Drill_Down` attachment
But, even though the client filter is global it only applies to half of the table. I observed this when I added up the red circles which is reflected in the drill_down attachment
Hi @mohamed.ruzli.moham ,
I'm not sure what the exact issue is. In the first screenshot #units is split based on the '# days', which results in 77 & 19. 77+19 = 96, which is the number you show in the second screenshot.
What are the expected values?
Hi @mohamed.ruzli.moham ,
I'm not sure what the exact issue is. In the first screenshot #units is split based on the '# days', which results in 77 & 19. 77+19 = 96, which is the number you show in the second screenshot.
What are the expected values?
The expected value should be 628 (77 + 0 + 19 + 532 + 0 + 0 ) in the 2nd screenshot
How are you calculating it, because based on the statement used, it might be that it only picks the first one, and not both 0-10 days.
Can you please check is there any component filter applied in the second table( 2nd screenshot) which is why it is taking only specific values.
May be that be the reason, I am not so sure but yeah you can try this out.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
