Dynamics Community Forum Thread Details

How to make "if conditions" in Dynamics work like Excel "if conditions" : Calculated fields

I have been trying to achieve the following in a if condition in a calulated field , Could you please help me the achieve this kind of values which are dynamic.

By default the if condition only allows a "static value" or a "field value " , is there any way i can have a computed "field value" as follows , this is the formula based on excel , i need to achieve the same in Dynamics calculated fields

=IF( 
    BX$4 <= $AI5, 
    IF( 
        OR( 
            BX$4 = $AH5 + 1, 
            BX$4 = $AH5 * 2 + 1, 
            BX$4 = $AH5 * 3 + 1, 
            BX$4 = $AH5 * 4 + 1, 
            BX$4 = $AH5 * 5 + 1, 
            BX$4 = $AH5 * 6 + 1, 
            BX$4 = $AH5 * 7 + 1, 
            BX$4 = $AH5 * 8 + 1, 
            BX$4 = $AH5 * 9 + 1, 
            BX$4 = $AH5 * 10 + 1, 
            BX$4 = $AH5 * 11 + 1, 
            BX$4 = $AH5 * 12 + 1, 
            BX$4 = $AH5 * 13 + 1, 
            BX$4 = $AH5 * 14 + 1, 
            BX$4 = $AH5 * 15 + 1, 
            BX$4 = $AH5 * 16 + 1, 
            BX$4 = $AH5 * 17 + 1, 
            BX$4 = $AH5 * 18 + 1, 
            BX$4 = $AH5 * 19 + 1, 
            BX$4 = $AH5 * 20 + 1 
        ), 
        BW5 * ( 1 + $AE5 ), 
        BW5 
    ), 
    0 
)

Categories:

Quick Links

Leaderboard