2 differents results for the same formula

[#1]

hello

   to improve the performance of my application I calculate my KPI in the script.
when  I calculate the KPI in the script, the give me an number but when i use the same formula in the application , i have another number
I summarize, if I calculate the same formula once in the scipt and once in the application, it gives me two different values

is that someone has an idea.

thank you

[swuehl]

Could you share the expressions you used in the script and in the front end for KPI calculation, please?

It would probably be best if you could also share a small sample file that demonstrates what you are observing.

[#3]

the formula :

count (distinct if(CALL_DIRECTION='O',A_NUMBER,if(PARTNER_CODE<>'PAH',B_NUMBER))) as NBR_Abonnées_ACtifs,

[vijay_iitkgp]

Hi,

It is obvious that it will give you different result.If you do it at front end it will give you distinct value on the base of your selection. but if you do it at back end (script) it will be base on the group by condition.

Hope this will help.

Also if you can let us know on what dimension you want to see the distinct count thenit will help us to understand more.

[nstefaniuk]

Maybe you have script modifiers like NullAsValue or NullDisplay that changes the value between the script and the chart ?