Forum Discussion

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

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]
)