Class fonction with 2 measures

bentley32 — Fri, 15 Oct 2021 20:04:10 GMT

Hello all,

I am using the class () fonction to create buckets that we can call buckets of amount and to create the buckets i am using the measure X,

My problem is the KPI inside my pivot that have the buckets of amount as a dimension : is a division between X and Y

Sometimes the Y is way different then the X, it means that my bucket will take into account the X and not the Y on the KPI division

and i am getting in my Bucket dimension nulls for the divisions between an X inside the range and a Y outside the Range

this is my code for the bucket :

DUAL(Replace(Class(X,'<= x <',' - '),Class(X+1))

and the measure used is X/Y

Thanks all for your help, its much needed

topic Class fonction with 2 measures in App Development