Hi there,
I have the need to create a few more complicated expressions than what is available by default (data is direct from Infor Data Lake). An example is below for a specific sales variable. The issue is that I run into a column not recognized error. I have tried editing the expression, shortening it, and just testing a portion of it but I need a way to capture complex iifs from multiple tables like this. I am unable to set grains/dimensions to create custom attributes/measures due to how the data is set up. Could someone help?
IIF(TOUPPER([OEEH.oeeh_transtype])= 'RM' OR TOUPPER([OEEH.oeeh_transtype])= 'CR',
IIF([PDER.pder_rebateamt] <> 0 AND TOUPPER([PDER.pder_rebatecd]) = 'C',
([oeel.oeel_netamt] - ([pder.pder_rebateamt] * -1 * [oeel.oeel_qtyship]) - [oeel.oeel_wodiscamt]) * [oeeh.oeeh_salesexrate],
(-1*[oeel.oeel_netamt] + [oeel.oeel_wodiscamt]) * [oeeh.oeeh_salesexrate]),
IIF(TOUPPER([OEEH.oeeh_transtype])= 'BL',
IIF([PDER.pder_rebateamt] <> '0' AND TOUPPER([PDER.rebatecd]) = 'C',
([oeel.oeel_netamt] - ([pder.pder_rebateamt] * [oeel.oeel_qtyship]) - [oeel.oeel_wodiscamt]) * [oeeh.oeeh_salesexrate],
([oeel.oeel_netamt] + [oeel.oeel_wodiscamt]) * [oeeh.oeeh_salesexrate]),
0))
Thanks.
