Subtract not working in expression...

[srini]

I have expression, as follows

=if([Cycle Name]='FORECAST',[Total Charge (000s USD)])-[Direct Cost]

but it is not giving me result it is only showing blank.

anything I missed?

[dplr-rn]

why is [Direct Cost] outside the if statement?

try changing to
=if([Cycle Name]='FORECAST',[Total Charge (000s USD)]-[Direct Cost] )

[m_woolf]

In addition to dilipranjith's reply, if either field is null the subtract will be null.

You can replace the subtract with: rangesum([Total Charge (000s USD)]),-[Direct Cost])