Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have below expressions:
vBucket = if(($(vsumA) < $(vA_hurdle) or trim(len($(vsumA))) <=1) and ($(vsumB) < $(vB_hurdle) or trim(len($(vsumB)))<=1), 'Low Low',
if(($(vsumA) < $(vA_hurdle) or trim(len($(vsumA))) <=1) and $(vsumB) > $(vB_hurdle), 'Low High',
if($(vsumA) > $(vA_hurdle) and ($(vsumB) < $(vB_hurdle) or trim(len($(vsumB)))<=1), 'High Low',
if($(vsumA) > $(vA_hurdle) and $(vsumB) > $(vB_hurdle), 'High High'))))
vsumA = sum(A_num)/sum(A_den)
vsumB = sum(B_num)/sum(B_den)
I want to show following summary: count, vSumA and vSumB for each bucket
This summary shouldn't change based on user selection.
I tried multiple things but couldn't find any solution.
Kindly help!
@sunny_talwar @swuehl @tresesco @Gysbert_Wassenaar
Thanks
This?
Thanks Sunny 🙂