Topic Options
#57496 - 05/15/18 01:20 PM Ledger 9.3A (180422) Provisional Posting
Steve Schwartz Offline
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 Offline
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 Offline
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


Moderator:  Christa_Meissner 
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