Skip to main content
Topics#Reports & DashboardsWill Forbes의 질문
Will Forbes (M&S) 님이 #Reports & Dashboards에 질문했습니다
2021년 1월 12일 오후 4:35

Calculate % through Calendar Quarter

I just need a basic formula to calculate the % through a quarter. We go off the basic 3 months Jan-Mar quarter, and just want it to calculate that %. I've looked around and can't find any formula that works for me.
답변 8개
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2021년 1월 12일 오후 5:47

    So basically something kinda like this?

    (
    TODAY() -
    CASE( CEILING(MONTH( TODAY() ) / 3 ),
    1 , DATE(YEAR(TODAY()),01,01),
    2 , DATE(YEAR(TODAY()),04,01),
    3 , DATE(YEAR(TODAY()),07,01),
    4 , DATE(YEAR(TODAY()),10,01),
    NULL )
    )
    /
    CASE( CEILING(MONTH( TODAY() ) / 3 ),
    1, 90,
    2, 91,
    3, 92,
    4, 92,
    0)

     

     
답변을 작성하세요...
0/9000