Sage MAS Intelligence

[kimg]

I have the following formula set up in my report and I keep getting an error that boolean is required and I cannot figure out where.  Can anyone look at this and help me please?

if tonumber ({JC1_JobMaster.RevisedContract})= 0
then {JC1_JobMaster.OriginalContract}-{@jtd billed}
else {JC1_JobMaster.RevisedContract}-{@jtd billed} and {@Ramaining Dollars}> 0

[rmikolainis]

This makes no sense:

{JC1_JobMaster.RevisedContract}-{@jtd billed} and {@Ramaining Dollars}> 0

[kimg]

Can you please tell me what is wrong with it?

[rmikolainis]

---

kimg wrote:

Can you please tell me what is wrong with it?

---

You're returning 2 values if

if tonumber ({JC1_JobMaster.RevisedContract})<> 0

[kimg]

I actually have two totals - one that includes my negative amounts and one that excludes the negative amounts.  The formula I posted was used to create the total including my negative amount and the other wasthe same formula copied and I'm tryingto exclude anything less than zero - which is what the last line means.  Do you know how to fix this?

[rmikolainis]

---

kimg wrote:

I actually have two totals - one that includes my negative amounts and one that excludes the negative amounts.  The formula I posted was used to create the total including my negative amount and the other wasthe same formula copied and I'm tryingto exclude anything less than zero - which is what the last line means.  Do you know how to fix this?

---

if tonumber ({JC1_JobMaster.RevisedContract})= 0
then {JC1_JobMaster.OriginalContract}-{@jtd billed}
elseif tonumber ({JC1_JobMaster.RevisedContract})= 0 and {@Ramaining Dollars}> 0

then {JC1_JobMaster.RevisedContract}-{@jtd billed}

else 0