Active Topics
Active Posts
Unanswered Posts
Search
Advanced
You are not logged in. [
Log In
]
Adagio Home Page
»
Forums
»
General Discussion
»
Technical Support
» Ledger 9.3A (180422) Provisional Posting
Register User
Forum List
Calendar
Active Topics
Search
FAQ
Topic Options
#57496
-
05/15/18
01:20 PM
Ledger 9.3A (180422) Provisional Posting
Steve Schwartz
Adagio God
Registered: 03/10/02
Posts: 4509
Loc: Wynnewood, PA
I know the answer is yes, but I need someone to open my eyes.
What formula do I use in a FR spec so that the column heading says (Provisional) if the Provisional "P" icon is toggled on?
In other words, I want the heading to toggle between "Actual" and "Actual (Provisional)" as the icon is toggled.
Thanks
Steve
Top
#57497
-
05/15/18
03:44 PM
Re: Ledger 9.3A (180422) Provisional Posting
[
Re: Steve Schwartz
]
Retired_Guy
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
Code:
=IF(PROVISIONAL()="","Actual","Actual (Provisional)")
You only need the IF() because you want the "Provisional" in "()".
_________________________
Andrew Bates
Top
#57498
-
05/16/18
07:26 AM
Re: Ledger 9.3A (180422) Provisional Posting
[
Re: Retired_Guy
]
Lyndon_Olfert
Adagio Specialist
Registered: 06/15/04
Posts: 362
Loc: Winnipeg
This is brilliant! It is always difficult to see whether "Provisional" is on or off. This makes so much sense!
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.
Top
Previous Topic
Index
Next Topic
Preview
Hop to:
General Discussion ------
General Inquiries Forum
Technical Support
Moderator:
Christa_Meissner
Print Topic
Switch to Threaded Mode
View profile
Send a PM
View homepage
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
View homepage
Add to your Watched Users
View posts
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key:
Admin
,
Global Mod
,
Mod
Forum Stats
1865
Members
5
Forums
14459
Topics
70635
Posts
Max Online: 432 @
01/20/25
10:17 PM
April
Su
M
Tu
W
Th
F
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Privacy statement
·
Board Rules
·
Mark all read
Default Style
Forum-Style
Forum-Style-New
Softrak_Blue
Contact Us
·
Adagio Home Page
·
Top