Forum Discussion
If Condition
Hello ,
please if you can help me with this measure :
i have 5 conditions need to make a remark column for each single one :
1- if AP_Payments = Blank , give me a remark ( Not Paid )
2- if AP_Lines = 0 or blank , give me ( Voided )
3- ap_lines -sar_payments > 0 , give me partially paid (* note , in ap _payments should be more than 0 to calculate the remaining )
4 - same as # 3 , as overpaid but need to make the remark for it as paid also
5 - if ap_lines = ap_payments , give me( fully paid )
Attached Image
Thank you
bhelou , You can create a new column like
Switch( True() ,
Isblank([AP_Payments]), "Not Paid",
coalesce([AP_Line],0) =0 , "Voided",
// Add others
[ap_lines] = [ap_payment] , "Fully Paid"
)
2 Replies
bhelou , You can create a new column like
Switch( True() ,
Isblank([AP_Payments]), "Not Paid",
coalesce([AP_Line],0) =0 , "Voided",
// Add others
[ap_lines] = [ap_payment] , "Fully Paid"
)
Thank you , worked perfect
