Hi , Need Help. Can I get [Total contract Value] result value below 2,000,000 only.

[AbdullahJamil]

Hi ,

Need Help.
Can I get [Total contract Value] result value below 2,000,000  only.

Review below command what I am doing wrong. 
Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value] < '2000000')

Thanks

Abdullah

[Vengatesh]

Try this

If(Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value] )<200000,Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value] ))

[AbdullahJamil]

Thanks for the reply.
no line appearing on chart with this command.

[Vengatesh]

what it shows? can you share the screenshot?

Try the below command

If(Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value] )<2000000,Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value] ),'NIL')

[sunny_talwar]

What is the chart dimension/s where you are using this expression?

[AbdullahJamil]

It's Combo chart with 1 dimension which are months and 3 expressions which are 2 Data Bars and 1 Data Line but Data line is not appearing .

Please find attached all 3 expressions Jpeg

[sunny_talwar]

Do you have less than, 2,000,000 for the last expression? Aggregating on the month level, may be each month have a value greater than 2,000,000 for your expression?

[AbdullahJamil]

Yes you are right. 

In my mind I want to remove only those individual bids while monthly sum which are more than 2 millions individually.

Thanks for helping guys 🙂 

Regards,

Abdullah

[sunny_talwar]

Sorry I am not sure I understand? Did you get what you wanted? or is there a question for us?

[AbdullahJamil]

Thanks for patience Sunny .

Still a question for you.
how to remove only those individual bids from [Total Contract Value] column while monthly sum which are more than 2 millions individually.

Need to correct below mentioned command
If(Sum ({<[Current Sell and Renew Gate] = {'Won','Gate 1','Gate 2','Gate 3'}>}
[Total Contract Value] )<2000000,Sum ({<[Current Sell and Renew Gate]
= {'Won','Gate 1','Gate 2','Gate 3'}>} [Total Contract Value] ),'NIL')