Two tables different numbers

[Former Member]

Hi,

I am having trouble with numbers from the two different tables below:

The values circled in purple should be the same in both tables. However, they are not.

The formula for the first table, for "Total: " is: ="Total: "+ Sum([Days Between W.O. Open Date and Forward TPS_CONFIG])

The formula for the second table, for "Total:" is: = Sum([Days Between W.O. Open Date and Forward TPS_CONFIG]foreach([W.O.]))

I don't understand why this does not reuslt in the same numbers. Both filters are the same. And for example, column #2 is right in both tables..

Thank you !

Geneviève Nantel

[Former Member]

I see you are calculating the sum at the granural level of date and WO and in the second table you are trying to it at year and WO level. Try using the below with context at date level to calculate both at same level and see if it matches.

= Sum([Days Between W.O. Open Date and Forward TPS_CONFIG] ) foreach([W.O.];[Year];[date])

Thanks

Mallik

[former_member189638]

I think you need to put the ForEach function outside the Sum parenthesis.. That is why it is calculating wrong values.

Sum([Days Between W.O. Open Date and Forward TPS_CONFIG]) ForEach([W.O.])

[Former Member]

Yes I tried already, but it does not work. Thank you !

[former_member188911]

In this type of situation is important to know how the data are structured and the patch level as well

thanks

SC