var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: round up/down decimal places in query
So i have this code in one query field:
Then this in another:
Taxed Totals: IIf([items for job transfer]![tax status]="t",[totals]*1.06,[totals])
The properties pane only gives me an option for decimlas on the first expression. I need to get the decimals down to 2 on the 2 expression. What gives??
506: IIf([class]="2",[taxed totals],"0")
That quick. I figured it out. It was the "0" in the second expression. I used "null" in its place.
FYI, you could probably also have used 0. The quotes made it get treated as text. You can probably also use the Round() function if appropriate to your needs.