Questions Variance formula in P&L statement incorrect Gross Profit & other profit sub total lines

Acumatica Analytical Report Manager (Financial Report Writer)

Last Post by Scott Whitley 2 years ago

3 Posts

1 Users

1 Reactions

960 Views

RSS

Posts: 5

Scott Whitley

Topic starter

May 7, 2024 10:50 am

(@swhitley)

Active Member

Joined: 3 years ago

=IIF((@RowCode>00100 AND @RowCode<00180) OR (@RowCode>00450 AND @RowCode<00470) OR (@RowCode=00250), B-C,C-B)

Lines 00100 thru 00180 are Sales; Lines 00450 thru 00470 and 00250 are profit to point summaries as in 00250 is "Gross Profit". Above formula works correctly on account line items but gives wrong sign and values the summary lines. Negative value will not calculate correctly when Actual is a negative value.

DPLDEPTDTL (2024-05-07).pdf

DPLDEPTDTL (2024-05-07) (3).pdf

2 Replies

Posts: 5

Scott Whitley

Topic starter

May 21, 2024 2:51 pm

(@swhitley)

Active Member

Joined: 3 years ago

Resolved

Posts: 5

Scott Whitley

Topic starter

May 21, 2024 2:51 pm

(@swhitley)

Active Member

Joined: 3 years ago

Resolved

12 Forums
2,533 Topics
11 K Posts
56 Online
2,438 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)