Help with formula - select both recently item what a list.

lcapon
lcapon
in Modeling

Hi.

 

Please could you help suggest how I can identify in an additional column what the both recently (bottom of the list) retention figure is? Most recently figure is the one highlighted below. This figure is pulled through to another dashboard but its currently provide the total sum.

 

lcapon_0-1636034424838.png

 

 

lcapon_1-1636034881425.png

 

SUM is being pulled through to here, how can i just return latest retention input? 

 

lcapon_2-1636034964885.png

 

 

Tagged:

Answers

  • thanasis
    thanasis
    If you can flag the latest retention period in the source module, you will should be able to use LOOKUP and only bring this value in the target module instead of the SUM
  • ankit_cheeni
    ankit_cheeni
    Hi,
    I see your summary module has only two dimensions of the three in your first image. What you can try doing is convert the number to text in another line and set the summary to Lastnonblank. Then if you directly refer the line item in the final summary module, you’d get the last text formatted value basis the two common dimensions. Convert it to number using VALUE function.

    I did not try it but I think it should work. Let me know 🙂

Categories