Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Please help me out i have below table. in this table i need to calculate like: if Due Date is D+0 it should count from 1 upwards e.g total is 1+2+2+1 = 6 and if Due Date is D+3 it should count from 4 upwards e.g total is 2 = 2. please help i cant get the logic behind that?
Thanks
IF([Due Date] = 'D+3' , Count({$<[Reason_Aging]={'>=4'}>}[DimensionYouAreCounting]),
IF([Due Date] = 'D+1' , Count({$<[Reason_Aging]={'>=2'}>}[DimensionYouAreCounting]),
IF([Due Date] = 'D+2' , Count({$<[Reason_Aging]={'>=3'}>}[DimensionYouAreCounting]) )))
Something like this i would guess.
what is the dimension being used to create third column of your example?
HI Dan
Thanks for your respond i used Reason_Aging as my dimension.
Thanks
IF([Due Date] = 'D+3' , Count({$<[Reason_Aging]={'>=4'}>}[DimensionYouAreCounting]),
IF([Due Date] = 'D+1' , Count({$<[Reason_Aging]={'>=2'}>}[DimensionYouAreCounting]),
IF([Due Date] = 'D+2' , Count({$<[Reason_Aging]={'>=3'}>}[DimensionYouAreCounting]) )))
Something like this i would guess.
Thanks Dan it is working perfectly.