Checking an expression against a Substring Value

[sunil2288]

Hi Everyone,

After a long period having some problem while developing finance analysis.

Actually i have a model where there is a field named "HFM_Code"which is having values like 'P0300000-Sales expenditure' which are string value . i need to calculate the sum(amount) incurred against the HFM_Code='P0300000' only.

How to resolve this ....

Reply appreciated

Thanks

Suneel

[Or]

Assuming the code and text description are always separated by a dash, you should be able to use the following:

left(HFM_Code,Index(HFM_Code,'-')-1)

If this isn't what you meant, please post sample data / expected result or a sample QVW.

[johnw]

If I understood the question, in the script:

subfield(HFM_Code,'-',1) as HFM_Code_Group

Then where you want to do the sum:

sum({<HFM_Code_Group={'P0300000'}>} amount)

[sunil2288]

Wow John.....

You understood my problem well and solved it quite comfortably.

Thank you very much