Forum Discussion
Solved
Parameter with condition
Hi everyone I need to add a second parameter which will kick in if (invoiced[ConsigneeName]) is "ABC" to apply a diffrenet price. Can someone assist with this? Much appreciated!!! thank you! ...
Hi cocoloco79
Based on your all inputs. Below code would required to get desired output:-
Estimated_market_price = VAR result = IF ( MAX ( Invoiced[Qty Invoiced] ) <> MAX ( Invoiced[Qty Sent] ), IF ( MAX ( Invoiced[Consignee] ) = "Kalfresh", SUM ( Invoiced[Estimated market price] ), SUM ( Invoiced[$/Unit] ) ) ) RETURN IF ( result = 0, 0, result )Output:-
Please let me know if it works for you.
Thanks,
Samarth
Hi Samarth_18
Yes, we are on the same page.
Can both calulation be run at the same time if those 2 conditions are met?
I have applied the two lines "Return result" but that didnt return the right resluts.
Thank you!
| Consignee | OuterProduct | Pieces | Qty Sent | Qty Invoiced | Weight | $/Unit | Gross Invoiced | Buyer Rebate | Freight | Packing | Marketing | Estimated_market_price | Estimated market price x 10 % | Estimated market price minus Estimated market price x 10 % | Marketing Discount Amount | Grower Return plus Estimated market price plus discount minus ETM 10% | Grower Return plus Estimated market price plus discount divided by Weight | Grower Return plus Estimated market price plus discount minus ETM 10% divided by Pieces |
| Kalfresh | CLCR - Organic Green Bean - Loose - 10kg Crate | 0 | 5149 | 4077 | 51490 | $41.79 | $170,385.10 | $0.00 | $8,513.87 | ######## | ######## | $0.00 | $0.00 | $0.00 | $0.00 | $4,007.57 | $0.08 | |
| A | PFST - Passionate Farmer - Organic - Green Beans - 10kg Styro | 0 | 468 | 256 | 4680 | $42.27 | $10,820.00 | $0.00 | $1,805.51 | ######## | $1,082.00 | $0.00 | $0.00 | $0.00 | $0.00 | ######## | -$1.17 | |
| B | PFCTN - Passionate Farmer - Organic - Green Beans - 10kg Carton | 0 | 262 | 190 | 2620 | $40.00 | $7,600.00 | $0.00 | $320.25 | $7,493.20 | $760.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$973.45 | -$0.37 | |
| C | PFCTN - Passionate Farmer - Organic - Green Beans - 10kg Carton | 0 | 246 | 222 | 2460 | $45.00 | $9,990.00 | $0.00 | $117.99 | $7,035.60 | $999.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,837.41 | $0.75 | |
| D | PFST - Passionate Farmer - Organic - Green Beans - 10kg Styro | 0 | 24 | 0 | 240 | $0.00 | $0.00 | $0.00 | $686.40 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$686.40 | -$2.86 | ||
| E | PFCTN - Passionate Farmer - Organic - Green Beans - 10kg Carton | 0 | 16 | 16 | 160 | $60.00 | $960.00 | $0.00 | $84.67 | $457.60 | $96.00 | $0.00 | $0.00 | $0.00 | $0.00 | $321.73 | $2.01 |
If both calculation will run then we need to sum both the output?
Hi Samarth_18
Yes thats right, we need to tolal them both up so the the end result.
i.e kalfresh priced at $10 and the rest priced at $20... need to total all values up.
Alright, then your final code would be as below:-
Estimated_market_price = VAR _kalfres_data = IF ( MAX ( Invoiced[Qty Invoiced] ) <> MAX ( Invoiced[Qty Sent] ), IF ( MAX ( Invoiced[Consignee] ) = "Kalfresh", SUM ( Invoiced[Estimated market price] ) ) ) VAR rest_data = IF ( MAX ( Invoiced[Qty Invoiced] ) <> MAX ( Invoiced[Qty Sent] ), SUM ( Invoiced[$/Unit] ) ) RETURN _kalfres_data + rest_dataThanks,
Samarth