Forum Discussion

jovendeluna21's avatar
jovendeluna21
Helper IV
1 year ago
Solved

Dynamic Value using Numeric Parameter in calculating Cashflow Opportunity

Hi, I need help instead of fixing the opportunity to 80 days, can we input a variable using numeric parameter and the cashflow opportunity will adjust?   Cashflow Opportunity - indicates the total...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Change your formula to this

    Adjusted Cashflow Opportunity = 
SUMX (
    ADDCOLUMNS (
        SUMMARIZE (
            'Table',
            'Table'[Supplier Name],
            'Table'[Net Days],
            'Table'[Spend]
        ),
        "@Cashflow",
           MAX( ( [Opportunity Variable Value] - [Net Days] ), 0 ) * DIVIDE ( [Spend], 360 )
    ),
    [@Cashflow]
)
jovendeluna21's avatar
jovendeluna21
Helper IV
1 year ago

Hi, danextian, I already solved it by modifying your given calculation:

Adjusted Cashflow Opportunity =
SUMX (
    ADDCOLUMNS (
        -- Calculated to be evaluated based on these columns
        SUMMARIZE (
            'Table',
            'Table'[Supplier Name],
            'Table'[Net Days],
            'Table'[Spend per Day]
        ),
        "@Cashflow",
            IF(
                [Opportunity Variable Value] <= [Net Days],
                0,
                ( [Opportunity Variable Value] - [Net Days] ) * [Spend per Day]
            )
    ),
    [@Cashflow]
)