topic Data Load Editor Invalid Expression in App Development

Data Load Editor Invalid Expression

Anonymous — Wed, 25 Oct 2017 02:13:51 GMT

Hi,

I am trying to use this expression in the data load editor to create a new table but I keep getting the invalid expression error.

If((1-(Sum(If(month= currentmonth, Spend))/Sum(If(month= currentmonth, Forecast)))) > .20, 'Red',

If((1-(Sum(If(month= currentmonth, Spend))/Sum(If(month= currentmonth, Forecast)))) > - .20, 'Green')) as RAG

What would need to be changed to make this able to work.

Regards,

William

Re: Data Load Editor Invalid Expression

nehasaxena — Wed, 25 Oct 2017 05:17:14 GMT

Hi William,

Please share the complete load script for this expression. If you are using any aggregation function in script like Sum you need to do group by for all the fields that you are loading from the table.

BR,

Neha

Re: Data Load Editor Invalid Expression

jonathandienst — Wed, 25 Oct 2017 05:29:57 GMT

Remove the space between the - and the .20

If(1 - Sum(If(month = currentmonth, Spend)) / Sum(If(month= currentmonth, Forecast)) > .20, 'Red',

If(1 - Sum(If(month = currentmonth, Spend)) / Sum(If(month = currentmonth, Forecast)) > -.20, 'Green')) as RAG

^^^

Re: Data Load Editor Invalid Expression

its_anandrjs — Wed, 25 Oct 2017 05:43:44 GMT

What error message you getting?

Try to write this way

If((1 - (Sum(If(month= currentmonth, Spend)) / Sum(If(month= currentmonth, Forecast)))) > 0.20, 'Red',

If((1 - (Sum(If(month= currentmonth, Spend)) / Sum(If(month= currentmonth, Forecast)))) > - 0.20, 'Green')) as RAG

Re: Data Load Editor Invalid Expression

Anonymous — Fri, 27 Oct 2017 00:47:58 GMT

I solved the issue by removing the sum from the expression.

Thanks.