Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you share sample application?
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
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