Hi,
Is it possible to create a formula without any comparison with a field in the database? What I mean is that I need a formula that has 3 texts (G.S.T. and Q.S.T. and H.S.T.). I want to create a group so I have those 3 taxes in my report. The thing is that I have sub-acounts for the taxes and I want to have the group G.S.T. first (sub-accounts 120, 210, 220, etc.), then the group H.S.T. (sub-accounts 120, 210, 220, etc.) and fining with the 3rd one. The sub-accounts are already a group. Is that possible? The report should look like this:
G.S.T. 120 $
G.S.T. 210 $
G.S.T. 220 $
Q.S.T. 120 $
Q.S.T. 210 $
Q.S.T. 220 $
H.S.T. 120 $
H.S.T 210 $
H.S.T. 220 $
Thank you in advance.
Anne
Is it possible to create a formula without any comparison with a field in the database? What I mean is that I need a formula that has 3 texts (G.S.T. and Q.S.T. and H.S.T.). I want to create a group so I have those 3 taxes in my report. The thing is that I have sub-acounts for the taxes and I want to have the group G.S.T. first (sub-accounts 120, 210, 220, etc.), then the group H.S.T. (sub-accounts 120, 210, 220, etc.) and fining with the 3rd one. The sub-accounts are already a group. Is that possible? The report should look like this:
G.S.T. 120 $
G.S.T. 210 $
G.S.T. 220 $
Q.S.T. 120 $
Q.S.T. 210 $
Q.S.T. 220 $
H.S.T. 120 $
H.S.T 210 $
H.S.T. 220 $
Thank you in advance.
Anne