Trying to add an excel expression and it errors out when running report out.

I'm taking 2 other excel expressions I added that work fine and ideally want this formula:

if (DepositAmt - Fifty) >= 0 then "Y" else "N"

DepositAmt and Fifty are excel expressions.

Any advice would be appreciated!

Views: 74

Reply to This

Replies to This Discussion

Don't think you can combine Excel Data Expressions names like that.

You will have to use both of the formulas from each of the Data Expressions in the new one.

Or us the PLPLUGA.A.ExtendFormulaeToUsedRows  Addin

Setting up the ExtendFormulaeToUsedRows Add-In


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service