Gross Markup info in rule

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Gross Markup info in rule

Post by numberz »

HI,
I am trying to perform a math function in a rule.
I need to smehow show "1-Object.Attribute"
It's the 1- that's giving me trouble.
BTW that would be ONE MINUS
Thank you.
Harry
Regards and thanks,
Harry Carter
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Gross Markup info in rule

Post by BLOMASKY »

Can you show an example of where you are having a problem? I use this all the time with expressions like:
OrderLine.price = ROUND(OrderLine.cost / (1 - Items.markUpPct),2)

Questions:
1). You did define the markup Pct as a number with decimal places right?
2). Are you entering a whole number or a precentage as the MU Pct. i.e. are you entering 10 or 0.10? Because if you use a whole number then you have to multiply it by 0.01 before proceeding.
3). Anywhere you have a constant fraction, are you prefacing it with a 0? 0.10 works, .10 does not

Bruce
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Gross Markup info in rule

Post by numberz »

Hi Bruce,
Yes, I have the pct down okay...it's just trying to enter the expression of say, "1-markup%"
Am I supposed to be putting that in parenthesis?

I actually used the full percentage then divided by 100. Same thing it seems?

I guess I'm asking how I could put "Cost/(1 - Markup) into an action.
Regards and thanks,
Harry Carter
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Gross Markup info in rule

Post by BLOMASKY »

does your expression look like mine? Yes, the (1-markupPct) has to be in parenthesis so that is done PRIOR to dividing the numerator.

Bruce
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Gross Markup info in rule

Post by numberz »

Yes, looks great, thank you.
Regards and thanks,
Harry Carter
Post Reply