Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi.
i wish to create the following nested if statement however my result is 0, although their is no sign of an exception
IF([Delivery Terms] < '50',
(Sum(If([Order Row No Discount] = 'N',
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Order Quantity]) * (1 + OrderRad_Rabatt),
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Order Quantity]) * (1+ [Order Header Discount]) * (1 + OrderRad_Rabatt))))
-
Sum((If([Order Row No Discount] = 'N',
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Levererat Antal]) * (1 + OrderRad_Rabatt),
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Levererat Antal]) * (1+ [Order Header Discount]) * (1 + OrderRad_Rabatt))))
however the problem seems to be that it returns 0.
when i choose delivery terms in the selection box however, then the result shows correctly.
any ideas how to achieve the following?
Best
Brad
Please try this for Total OrderStock:
(Sum ({1<[Delivery Terms]={"<=50"}>}(If([Order Row No Discount] = 'N',
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Order Quantity]) * (1 + OrderRad_Rabatt),
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Order Quantity]) * (1+ [Order Header Discount]) * (1 + OrderRad_Rabatt))))
-
Sum({1<[Delivery Terms]={"<=50"}>}(If([Order Row No Discount] = 'N',
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Levererat Antal]) * (1 + OrderRad_Rabatt),
([Förs pris] * if(isNull([Förs-kurs]),1,[Förs-kurs]) * [Levererat Antal]) * (1+ [Order Header Discount]) * (1 + OrderRad_Rabatt))))
)
Hi that fix is already applied on Total Orderstock, the KPI i wish to define is below and is called Warehouse Orderstock.
Best
Brad
Oops.Please use this for Warehouse Orderstock
Sum(If([Order Row No Discount] = 'N' and [Delivery Terms] < 50,
[Förs pris] * Alt([Förs-kurs] * [Order Quantity],1) * (1 + OrderRad_Rabatt),
([Förs pris] * Alt([Förs-kurs] * [Order Quantity],1) * (1+ [Order Header Discount]) * (1 + OrderRad_Rabatt))))
-
Sum(IF([Delivery Terms] < '50' and [Order Row No Discount] = 'N',
[Förs pris] * Alt([Förs-kurs] * [Levererat Antal],1) * (1 + OrderRad_Rabatt),
([Förs pris] * Alt([Förs-kurs] * [Levererat Antal],1) * (1+ [Order Header Discount]) * (1 + OrderRad_Rabatt))))