Show value

[rbvcbr]

I have the following formula, if there is
no amount I want show $100 (meaning now blank row).
But the following formula is not showing any
value. Can somebody please fix the formula.
Thank you,

if {CURRENT__TRANSACTION.Accounting_Date} < 8/1/2009
then
if isnull(({CURRENT__TRANSACTION.Amount})) then
({CURRENT__TRANSACTION.Amount}+100) else
({CURRENT__TRANSACTION.Amount})

 

[SchwabTerex]

Don't try to add {current_transaction.amount} to 100. Crystal can't add a number to NULL. If 100 is the answer you want just do

...then
100
else
{current_transaction.amount}

 

[rbvcbr]

See below, output data, watch on left after 02 is missing,
02 should be showing 100. Check my formula also. May be something wrong in the formula. Thank you.


Description --- Amount
01. Desc. One --- 14,531
03. Desc. Two --- 318,605
04. Desc. Three --- 227,227
05. Desc. Four --- 298,741
06. Desc. Five --- 85,557
07. Desc. Six --- 12,833
08. Desc. Seven --- 12,578


formula;
if {CURRENT__TRANSACTION.Accounting_Date} < 8/1/2009
then
if isnull(({CURRENT__TRANSACTION.Amount})) then 100
else ({CURRENT__TRANSACTION.Amount})

 

[SchwabTerex]

Sorry, I didn't get that there was no record in the table at all for that instance. I was just thinking of a null field. Let mw think about it - that is a bigger problem.

 

[rbvcbr]

Thank you for the reply, hope you will find the answer.

This data is grouped by description and showed totals only. Detail records are suppressed. Since "02" does not have data/amounts, I just want to show like below


02.Description --- 100.00


Thank you,

 

[Turkbear]

Hi,
Where is the 02.Description part coming from?

If NO record exists for an item ( even a description record)
then it cannot be reported on.

Can you show your table structure?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[rbvcbr]

Please see below, real data. Here I have '02', grouped by descripion, where it has real costs. I have groups by descrition 1 to 34. My goal is, I want to show $ 100 (could be $.10c) where there are no costs for that group, means I want to show all 34 lines/rows. Hope this helps. Thank you.

[table structure has over 100 fields, I picked these].

Description --- Cur_Cost--- Ttl_Cost
02. Pre-Const --- 0 --- 24,000
03. Project Mgt --- 16,775 --- 53,452
05. Field Labor --- 0 --- 352
08. Expeding --- 0 --- 1,400
11. Blueprint --- 1,332 --- 13,918
12. Postage --- 311 --- 4,656
25. Phones --- 12 --- 12
34. Misc. --- 314 --- 453
Grand Total --- 18,744 --- 98,243