Split logic in straight table

[abc_18]

Hi Team,

I am using a straight table with dimensions and expressions. 

I am comparing two fields ’ vendor_split and ID vendor from two different table, and replacing Proforma Invoice NO with id row if it is NULL.

My expression for Amount LCY with Split column is  :-

IF(([Proforma Invoice No] = 'Null' and Vendor_Split = 0) ,(split*total_amount_fct)/100

,if(([Proforma Invoice No ]= 'Null' and Vendor_Split = idvendor), (split*total_amount_fct)/100

)

)

Required o/p:-

1> if vendor_split=idvendor then only that particular row should come .means only one row

2> if vendor_split<> idvendor then records with zero value from vendor_split should come.

[PradeepReddy]

can you share sample application?

[hic]

First, you cannot use

     [Proforma Invoice No ]= 'Null'

Instead you should use one of the following

     IsNull([Proforma Invoice No ])

     Len(Trim([Proforma Invoice No ]))= 0

Secondly, you should not use naked field references. The calculations are aggregations, so you need to wrap field references in aggregation functions. See Use Aggregation Functions!

HIC

[NareshGuntur]

Hi Shikha,

Your query seems confusing. You better load a sample data(a few rows with values changed) and attach the document here to gain much attention.

Cheers,

Naresh