Hello community,
I hope you can help me.
I have a simple problem I think, but too difficult for me
Here my Formula that not works
(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Vorgang beendet],
REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))
+
(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Ausgleichsbeleg_gend.],
REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))
+
(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Vorgang auf Status Zurckgeschickt gesetzt.],
REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))
if I speak e.g. with numbers, it is like
7,6
+
8,5
+
-= - (dont work)
another examble
7,6
+
8,5
+
5
= 21,1 (work)
My Problem is the - (it is like
#NV
or no result). This case can happen and is not wrong.
The formula only works as long as each of the 3 numbers occurs. But if one of the 3 numbers is missing and the partial result is -, the formula does not work.
I need a solution to convert my - to a 0 for the addition formula to work
Hope you can help me
Greedings from Steven
