Topic Options
#57259 - 04/18/18 11:21 AM Gridview formula help please
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Can someone help me please with this gridview formula?

I was successful in this formula:

IF({Tax Group}= " ON",{GST/HST},0)

However, now I want to add if the tax group is ON OR QC.

IF({Tax Group}= " ON",
OR({Tax Group}= " QC",
{GST/HST},0)

But when I do this my evaluation fails. I've tried various ways to add the OR statement but I'm doing something wrong.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#57260 - 04/18/18 11:23 AM Re: Gridview formula help please [Re: SusanTennier]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Code:
IF(
   OR(
        {Tax Group}= " ON",
        {Tax Group}= " QC"
   ),
{GST/HST}
,
0)
_________________________
Andrew Bates

Top
#57261 - 04/18/18 11:25 AM Re: Gridview formula help please [Re: Retired_Guy]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Thanks!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Softrak Support), 123 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70648 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