SQL Server Performance

Formulae

Discussion in 'SQL Server 2008 Analysis Services' started by radha_k_ds, Sep 6, 2011.

  1. radha_k_ds New Member

    Hi all can somebody help me to built below formulae in MDX


    Bal Date diffarance A_Value(diffarance*Bal)
    100 1-1-2002 12 1200
    200 12-1-2002 5 1000
    300 17-1-2002 14 4200
    (Next Date is ---- --------- -----------
    end of the month) 31--->Count 6400-->Total


    Formulae =Total/Count
    radha_k_ds, Sep 6, 2011
    #1

  2. satya Moderator

    Welcome to the forums.
    Are these are members in a hierarchy?
    satya, Sep 8, 2011
    #2

Share This Page