Skip to main content
Topics#Reports & DashboardsQuestion de Will Forbes
Will Forbes (M&S) a posé une question dans #Reports & Dashboards
12 janv. 2021, 16: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 réponses
  1. Steve Molis (You Owe Me a Beer, Inc.)
    12 janv. 2021, 17: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)

     

     
Rédiger une réponse...
0/9000