Hey Sunny and Luis,
first of all thanks for your requests.
For some reason, without having changed anything, the garbage error disappeard. Nevertheless, the KPI shows no result at all.
Attached you will find a screenshot for the KPI formular and a screenshot for the manually calculated variable year_flag. All other variables in the formular are just input data that is without an error because e.g. another KPI using the same input data is working properly:
Can you solve this issue?
Thanks a lot.
Your provided formula doesn't work.
My provided formula? Hahahaha, I just asked you to test this expression for me... and this is just the false part of the if condition.... so, I guess we know that the problem is in the above expression
-(Sum(Target_rev * year_flag)-Sum(Erloese_Netto*year_flag))/Sum(Target_rev)
Can you further break it down into three expressions
1) Sum(Target_rev * year_flag)
I am guessing that the third expression will not have any issues... It appears to be an issue with multiplication with year_flag variable....
Out of curiosity, what happens if you remove the = sign from your variable definition and then try it these two ways
Sum(Target_rev * year_flag)
Sum(Target_rev * $(year_flag))
Does one of these two work for you?
Based on your support I could find the error, thank you very much.
I figured out that the year_flag is the issue. As I am still working with data from 2017 and we have already arrived in 2018, the year flag for my data set was "0" in all cases. As a consequence, my KPI could just display "0".
Removing the year_flag solves the issue and provides me with the right results.
I'm sorry for having bothered you with such a simplistic error