on 08-10-2017 4:14 PM
Hello Friends,
I am struggling with a if and else statement in WebI, thought i post it here for quick help.
=If
([V100 2012].[Net Forecast]=0 Or IsNull([V100 2012].[Net Forecast]))
Then ([V200 2012].[Net Forecast])
ElseIf
([V200 2012].[Net Forecast]=0 Or IsNull([V200 2012].[Net Forecast]))
Then ([V300 2012].[Net Forecast])
Else
([V100 2012].[Net Forecast])
This statement does not seem to be working in a situation where variable [V100 2012].[Net Forecast] has a value greater than 0 and [V200 2012].[Net Forecast] & [V300 2012].[Net Forecast] is either 0 or null as it should give the value for [V100 2012].[Net Forecast] but instead produces the value for [V300 2012].[Net Forecast]
Can someone please help.
Thanks.
what about if you add one more if-else condition?
=If
([V100 2012].[Net Forecast]=0 Or IsNull([V100 2012].[Net Forecast]))
Then ([V200 2012].[Net Forecast])
ElseIf
([V200 2012].[Net Forecast]=0 Or IsNull([V200 2012].[Net Forecast]))
Then ([V300 2012].[Net Forecast])
elseif
([V100 2012].[Net Forecast]>0 Or IsNull([V200 2012].[Net Forecast]
or IsNull([V300 2012].[Net Forecast])))
Then ([V100 2012].[Net Forecast])
else
([V100 2012].[Net Forecast])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.