Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am trying to create an accumulative chart with some IF conditions but the result is not accumulated properly.
My formula:
IF('$(vProduct)'='A',rangesum(above(Count(distinct {<[Product Type]={‘A’}>} Customer ID)),0,rowno()),
IF('$(vProduct)'=’B’,rangesum(above(Count(distinct {<[ Product Type]={‘B’ }>}customer ID)),0,rowno()),
IF('$(vProduct)'='C',rangesum(above(Count(distinct {<[ Product Type]={'C'}>}customer ID)),0,RowNo()),
IF('$(vProduct)'='ALL',rangesum(above(count(distinct(customer ID))))))))
My result will be something like below if i use above expression.😢
Appreciate if you could enlighten me.
Thanks!
Hi
$(vProduct) -- is selected by user in filters? ie. At a time, one if condition will be executed?
Try like below
=rangesum(above(IF('$(vProduct)'='A',Count(distinct {<[Product Type]={‘A’}>} Customer ID),
IF('$(vProduct)'=’B’,Count(distinct {<[ Product Type]={‘B’ }>}customer ID),
IF('$(vProduct)'='C', Count(distinct {<[ Product Type]={'C'}>}customer ID),
IF('$(vProduct)'='ALL',count(distinct(customer ID)))))),0,rowno(Total)))
@CanCan Can you please provide some sample data?
Hi
$(vProduct) -- is selected by user in filters? ie. At a time, one if condition will be executed?
Try like below
=rangesum(above(IF('$(vProduct)'='A',Count(distinct {<[Product Type]={‘A’}>} Customer ID),
IF('$(vProduct)'=’B’,Count(distinct {<[ Product Type]={‘B’ }>}customer ID),
IF('$(vProduct)'='C', Count(distinct {<[ Product Type]={'C'}>}customer ID),
IF('$(vProduct)'='ALL',count(distinct(customer ID)))))),0,rowno(Total)))
@MayilVahanan Thanks for the big help!!!!! It worked!!!!!😊
Hi
Happy to know that, Can you please close the thread?