Inputsum with Set Modifier

[Anonymous]

Greetings,

I am trying to add a set modifier into to the following:

=InputSum(ADD_AMOUNT,'*')

to get:

=InputSum(ADD_AMOUNT,'*' {<Account = 'Asset'>})

However i get a 'Error in expression' as soon as i add it to the previous - already working inputsum

I'm afraid there is a syntax error that i cant seem to grasp.

I have tried looking online for examples but failed

Any thoughts?

Thank you

[kusumanchir · Accepted solution]

Hi Byran,

Please try this,

=InputSum({<Account = 'Asset'>}ADD_AMOUNT,'*' )

Regards,

Rasly.K

[kusumanchir]

Hi Byran,

Please find the sample attached with set analysis expression.

-Rasly.K

[Anonymous]

Hi,

Thank you for that.

One more question, is it possible to put an IF statement in the inputsum. I need some sort of workaround to prevent the user from putting negative values for example

Thanks

[kusumanchir]

Hi Byran,

Do you mean to say, display only the sum of positive values using inputsum() or not to allow users to input negative values ?

-Rasly.K

[kusumanchir]

Hi Byran,

Please find the modified sample app.

Created a chart with the name 'To exlcude -ve values'.

Let me know if it meets your requirement.

Regards,

Rasly.K

[Anonymous]

Hi Rasly sorry for the delay.

Unfortunately i cannot open the file as i am in Personnal Edition.

Many thanks though. My knowledge in Input sum has increased since then

Thanks