Need a formula correction (1 Viewer)

[sandya]

Hi friends, can anyone help on my issue

i have attached the screenshot with explanation. how to change the formula as per screenshot issue.


Amount: CCur([Qty1]+[Qty3]-[Qty2])*[SPrice]*(1-[Disc]))

Thanks,
Sandhya.

 

[pbaldy]

Are you wanting to show the value as positive, or to show a 0 when the value would be negative?

 

[sandya]

yes, Amount filed is show the value as positive.

when the Qty1 value is "0" that time Amount value shown a negative value becuase currently using the formula problem

i think need to change the formula that is based on Qty1 with value or without value...

i have used the below formula also but didn't work can you please help how to make a changes

Amount: IIf(CCur(Nz(([Qty1]+[Qty3]-[Qty2])*[SPrice]*(1-[Disc]),0))=0,CCur(Nz([Qty2]-[Qty3])*[SPrice]*(1-[Disc]),0),CCur(Nz(([Qty1]+[Qty3]-[Qty2])*[SPrice]*(1-[Disc]),0)))

 

[pbaldy]

Well, if you want the negative to display as positive, wrap your calculation in the Abs() function.

 

[sandya]

Thanks for suggestion, i will try this

 

[pbaldy]

No problem.